how to retrieve the top 2 salaried persons from a database?

Answer Posted / anusreekr

An error is occuring saying "unknown column rownum".
Please let me know where rownum feature is available in all
the mysql versions.The server version i am using is 5.5.21.

Thanks

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clause?

610


What are different categories of sql commands?

634


How many developers work on postgresql?

568


write an sql query to find names of employee start with 'a'? : Sql dba

579


Why do we create stored procedures & functions in pl/sql and how are they different?

504






How to select 10 records from a table?

650


explain advantages of myisam over innodb? : Sql dba

605


Explain the uses of database trigger.

654


What are the different types of functions in sql?

515


Explain the order of sql statement execution?

613


What are predefined functions in sql?

535


what is the difference between truncate and drop statements? : Sql dba

554


What is sql*loader and what is it used for? : aql loader

624


What is a database event trigger?

597


What are inner outer left and right joins in sql?

519