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

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

923

What are the other commands to know the structure of a table using mysql commands except explain command?

958

Does uninstalling mysql delete database?

945

Is mysql port 3306 tcp or udp?

873

What is mysql slow query?

897

What is join in mysql? What are the different types of join?

888

How to store values to array from mysql database in php?

874

How do you create a primary key?

928

What is default schema in mysql?

870

What is text in mysql?

856

Is mysql open source?

858

How we can create index in mysql?

920

Where’s database data actually stored?

902

How to display top 10 rows in mysql?

976

Which datatype is used for email in mysql?

908