Find out the 3rd highest salary?
Answer Posted / jeevitha
select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you sort in sql?
what is the difference between delete and truncate commands? : Sql dba
What is meant by <> in sql?
Explain sql data types?
What jobs use sql?
What is attribute indicator in pl sql?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is primary key and unique key?
How do I run a sql query in pgadmin 4?
what is isam? : Sql dba
what is error ora-03113: end-of-file on communication channel?
Explain how to use transactions efficiently : transact sql
what are myisam tables? : Sql dba
what are the join types in tsql? : Transact sql
What is the purpose of my sql?