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

What do we use to remove duplicate records while fetching a data in mysql ?

924

How much does mysql cost?

866

What is the latest version of mysql?

941

What is use of mysql?

889

How do I edit a table in mysql?

849

how to get only updated, deleted , inserted records after certain interval time in mysql with out using triggers...

2202

What is a select query?

820

List data types in mysql? Explain

879

What is max_used_connections in mysql?

913

How to show table structure mysql?

962

How many ways to get the current time?

929

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

869

What is myisamchk?

919

How do I truncate all tables in mysql?

932

Can varchar be primary key?

890