Skip to content

Commit 9e8c8d8

Browse files
Update SQL_Class_4.txt
1 parent fb955d4 commit 9e8c8d8

1 file changed

Lines changed: 3 additions & 0 deletions

File tree

SQL_Class_4.txt

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -55,3 +55,6 @@ insert into employees values(1,'Shashank',5000),(2,'Amit',5500),(3,'Rahul',7000)
5555
select * from employees;
5656

5757
# Write a query to print all those employee records who are getting more salary than 'Rohit'
58+
59+
# Wrong solution -> select * from employees where salary > 6000;
60+
select * from employees where salary > (select salary from employees where name='Rohit');

0 commit comments

Comments
 (0)