Answer Posted / suresh
select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
what is schema? : Sql dba
How many tables can you join in sql?
What is meant by truncate in sql?
how to show all tables with 'mysql'? : Sql dba
What is group function in sql?
Explain the steps needed to create the scheduled job?
What is a crud api?
What is rownum in sql?
What is the maximum number of rows in sql table?
What is restrict in sql?
Is drop table faster than truncate?
what is bcp? When is it used?
what is the difference between nested subquery and correlated subquery?
What is clustered index sql?
What makes a good primary key?
