Find out the 3rd highest salary?
Answer Posted / srikanth
select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
what is a record in a database ? : Sql dba
What are different joins used in sql?
what is log shipping? : Sql dba
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I write a sql query in pgadmin 4?
What is the use of desc in sql?
what is unique key constraint? : Sql dba
Does sql support programming?
What is cold data?
What is a data manipulation language?
Are sql database names case sensitive?
what is collation? : Sql dba
Can you have more than one key in a database?
What is group function in sql?
What does pragma mean?