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

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

Please Help Members By Posting Answers For Below Questions

How do I create a schema in mysql?

870

What is a mysql view?

835

How do I quit mysql?

932

Which datatype is used for email in mysql?

952

What is procedures in mysql?

935

What are the security alerts while using mysql?

1030

Is oracle better than mysql?

883

How do I start mysql in ubuntu?

1030

What is the difference between unix timestamps and mysql timestamps?

1013

What is a session in mysql?

965

How to show table structure mysql?

1004

how you will Create a database on the mysql server with unix shell.

1036

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1017

How will show all records containing the name "sonia" and the phone number '9876543210'

901

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

1187