how to find the second highest salary from emp table?
Answer Posted / r.arjunarao
select a.sal from emp a where 2=(select count(distinct(b.sal)) from emp b where b.sal>=a.sal)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How many aggregate functions are available there in sql?
How long will it take to learn pl sql?
What are aggregate and scalar functions?
What is procedure function?
Can we rollback after truncate?
What is nosql vs sql?
what is meant by urlencode and urldocode? : Sql dba
What is a crud api?
What are sql data types?
Can we have two clustered index on a table?
How do you delete duplicates in sql query using rowid?
What is dml with example?
What is cursor in pl sql with examples?
What are the methods of filing?
what is the difference between delete and truncate commands? : Sql dba