please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / vardhan rao
With Limit: nth highest salary
Select distinct(salary) from tablename order by salary desc
limit n-1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Which is faster mongodb or mysql?
How to get data from mysql in php?
Is mysql good for large database?
What is the command used to create a database using php and mysql?
What is the difference between MyISAM Static and MyISAM Dynamic?
Is mysql relational?
What is mysql uuid?
What is the difference between mysql and oracle?
What are slow queries?
change column name and make a unique column so we get no dupes.
How set mysql root password?
How are mysql timestamps seen to a user?
Does mysql use tcp or udp?
What is the difference between database and table?
Who owns mysql database?