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

can you tell the order of sql select statement? : Mysql dba

851

What are the advantages of mysql in comparison to oracle?

969

What is procedural api?

932

What is insert query in mysql?

847

Where is the myisam table stored?

903

How to see the create table statement of an existing table?

986

What is the datatype of image?

898

How to create a new table by selecting rows from another table in mysql?

924

Difference between CHAR and VARCHAR?

1022

Is mysql still popular?

871

What is the difference between having and where clause in mysql? Explain

954

Is mysql a odbc?

856

How do I show all mysql databases?

923

What is text?

899

What is the difference between mysql and pdo?

897