please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / prasun
SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 0,1
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
how to Return total number of rows.
How to insert dynamic values in mysql using php?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
What is mysql default database?
What is the difference between mysql and oracle?
What is the difference between BLOB AND TEXT?
how to add a new column to an existing table?
What is ddl, dml, and dcl?
explain GROUPBY & HAVING clause with examples.
How do you login to MySql using Unix shell?
What are the 5 r's of managing behaviors?
how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?
What is the difference between char and varchar in mysql?
Is foreign key indexed mysql?
How do I flush privileges in mysql?