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

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

Question Posted / hamza tariq

Answer Posted / hamza tariq

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many rows we can insert in a mysql table?

965

How can we change the data type of a column of a table?

1001

using primary can we relate two table, with out foreign key?

2712

What is the full meaning of mysql?

969

What is clob datatype?

887

What is the limit of mysql database?

962

What is difference between function and procedure in mysql?

962

How do I change a procedure in mysql?

1012

What are mysql queries?

928

What is mysqli_num?

943

How do I run mysql?

1014

How do I kill a mysql connection?

909

How do I create a stored procedure in mysql?

900

How do I find the database name in mysql?

955

What does innodb stand for?

976