Answer Posted / srinath reddy
select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);
instead of answer we can say this as a solution where we can
find nth also
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is difference between sql function and stored procedure?
what is isam? : Sql dba
How is debugging done?
What is offset and limit in sql?
What is pl/sql table? Why it is used?
Which constraints we can use while creating database in sql?
what is sub-query? : Transact sql
What is graph sql?
What is a sql select statement?
Are left and right joins the same?
Is grant a ddl statement?
What is execution plan in sql?
What is sql in java?
Can we create index on primary key?
how many columns can be used for creating index? : Sql dba