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

How can the performance of a trigger be improved?

774


What is the difference between delete and truncate statement in sql?

683


What are the commands used in sql?

738


What is the purpose of the partition table?

754


What is mutating table error?

882






what is self join and what is the requirement of self join? : Sql dba

859


What does dml mean?

738


Explain the uses of database trigger.

846


What is sql basics?

782


What are sql queries used for?

762


Explain lock escalation? : Transact sql

867


What are different types of triggers?

738


Explain the significance of the & and && operators in pl sql.

748


What are the ways on commenting in a pl/sql code?

674


how tsql statements can be written and submitted to the database engine? : Transact sql

714