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

What is mysql_pconnect?

914

how to display nth highest salary from a table in a mysql query? : Mysql dba

1067

What are the non-standard sql commands supported by 'mysql'?

998

How can we get total number of records by query in mysql?

911

Can foreign key have duplicate values?

898

What is data node in mysql cluster?

993

What is slow query log in mysql?

1110

What is bigint in mysql?

929

What are the 5 r's of managing behaviors?

1089

What is memory table in mysql?

948

What are date and time data types in mysql?

1028

What is the difference between mysql and oracle?

969

How do I clear a mysql database?

962

Can mongodb replace mysql?

942

Write a query to count the number of rows of a table in mysql.

937