please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 6745 Views
- I also Faced
- E-Mail Answers
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
What is unsigned in mysql?
How do I transfer data from one database to another in mysql?
What is mysql optimization?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
How do I install mysql on windows 10 64 bit?
What is the difference between b-tree and hash indexes?
What is a session in mysql?
Create table employee (eno int(2),ename varchar(10)) ?
How to copy data from one server to another using php?
How do we delete a row in a table?
Do while loop in mysql procedure?
What is localhost in mysql?
What are the ways in which you can retrieve data in the result set of mysql using php?
What is the usage of "i-am-a-dummy" flag in mysql?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
