adspace


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

please give me the answer for this:
query which generates the second highest integer in the table?

Question Posted / richa

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


Please Help Members By Posting Answers For Below Questions

Which statement is used in a select query for partial matching?

1247

What is the current mysql version?

1103

How to Change a users password from unix shell.

1222

What is current version of mysql?

1083