Interested to Buy Any Domain ? << Click Here >> for more details...
please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 8747 Views
- I also Faced
- E-Mail Answers
Answer Posted / richa
This is a general solution to nth level of salary
Select salary from (select salary from table order by salary
desc limit 3) tbl order by salary limit 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How would you get the current date in mysql?
What are the other commands to know the structure of a table using mysql commands except explain command?
How to use regular expression in pattern match conditions?
What are different types of queries?
Explain timestamp?
Can you tell few best practices to be followed for optimization in sql?
Does mysql support nosql?
How to store binary data in mysql?
Does mysql case matter?
How do I change the max connections in mysql?
Is mysql better than oracle?
How to create a new table by selecting rows from another table in mysql?
What is field in mysql?
What is a scalar function?
How to get the number of rows selected or affected by a sql statement?
