Find out the 3rd highest salary?
Answer Posted / satya
Hi,
Select sal from emp e where 3>=(select count (Sal)
from emp where sal>e.sal) order by sal desc;
Regards,
Satya.k
| Is This Answer Correct ? | 23 Yes | 35 No |
Post New Answer View All Answers
Can we create table inside stored procedure?
what is denormalization. : Sql dba
How do I start sql from command line?
Can we use insert statement in function?
What is before trigger?
how to include comments in sql statements? : Sql dba
Is json a nosql?
How do you explain an index?
What is execute immediate?
What is not null in sql?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
How exception is different from error?
What is the use of double ampersand (&&) in sql queries? Give an example
What is sql in java?
Does sql require a server?