How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / m haribaskar
Select Salary From Employee a Where 5=(
Select Count(Distinct Salary) From Employee b
Where a.Salary <= b.Salary )
Is This Answer Correct ? | 25 Yes | 7 No |
Post New Answer View All Answers
what is sql in mysql? : Sql dba
Can we create table in function?
What found sql?
Explain the methods used to protect source code of pl/sql.
What is sql procedures and functions?
What are predefined functions in sql?
What is integrity in sql?
Where do we use pl sql?
Explain what is a view?
Can a table contain multiple foreign key’s?
What are local and global variables and their differences?
What is the use of triggers?
How can I tell if sql is running?
Is sql scripting language?
Explain how exception handling is done in advance pl/sql?