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 show table names with 'mysqlshow'?
What does mysql flush tables do?
What is 'mysqlshow'?
What is the difference between primary key and candidate key?
How large can a mysql table be?
What is the data type for image?
What is the difference between char and varchar in mysql?
How to enter Characters as HEX Numbers?
What does blob mean in mysql?
What is latest version of mysql?
Do you need a license for mysql?
How do I connect to a database in mysql workbench?
Can you tell how to find the number of rows in a resultset using php?
How can I compare two mysql databases?
How to load data files into tables with 'mysqlimport'?