how to findout the 100th maximum salary

Answer Posted / gani

SELECT sal FROM table_name
ORDER BY sal DESC
LIMIT(99,1);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does truncate mean in sql?

534


Why do we use %rowtype & %type in plsql?

601


How to combine two stored procedures in sql?

591


How do I edit a trigger in sql developer?

537


How do I quit sql?

495






How many types of functions are there in sql?

501


What are field types?

535


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

502


explain about mysql and its features. : Sql dba

543


What does the file extension accdb stand for?

545


Why stored procedure is faster than query?

515


Do foreign keys improve performance?

543


How many parts of a pl sql block are optional?

515


What is pivot query?

591


Is sql the best database?

498