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

What is restrict in sql?

556


What is the process of copying data from table a to table b?

599


How can we implement rollback or commit statement in a trigger?

581


How many rows can sqlite handle?

587


What is having clause in sql?

529






What does an inner join do?

561


Does pdo prevent sql injection?

520


Can we use having without group by in sql?

553


Do ddl statements need commit?

540


What are the types of subqueries?

573


What are the string functions in sql?

530


How do you drop a trigger?

542


Is sql scripting language?

527


When should I use nosql database?

553


What is nvl?

614