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 / sunil kumar

Answer Posted / sunil kumar

Sorry I have a mistake in above answer. The right answer is

select marks from tablename order by marks desc limit 1,1

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1105

What is current version of mysql?

1084

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

1247

How to Change a users password from unix shell.

1223