how to findout the 100th maximum salary

Answer Posted / sudheer

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=salary

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you delete a table?

765


What is a full join?

707


Can procedure in package be overloaded?

837


Why are indexes and views important to an organization?

679


Are subqueries faster than joins?

726






How do I debug a stored procedure?

811


What does a pl/sql package consist of?

720


how can we find the number of rows in a table using mysql? : Sql dba

790


How do I write a sql query in pgadmin 4?

712


what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

738


What is sql lookup?

683


What is left inner join in sql?

725


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

841


Does a primary key have to be a number?

689


What is pl sql commands?

730