please give me the answer for this:
query which generates the second highest integer in the table?
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 |
Post New Answer View All Answers
What is mysql_pconnect?
how to display nth highest salary from a table in a mysql query? : Mysql dba
What are the non-standard sql commands supported by 'mysql'?
How can we get total number of records by query in mysql?
Can foreign key have duplicate values?
What is data node in mysql cluster?
What is slow query log in mysql?
What is bigint in mysql?
What are the 5 r's of managing behaviors?
What is memory table in mysql?
What are date and time data types in mysql?
What is the difference between mysql and oracle?
How do I clear a mysql database?
Can mongodb replace mysql?
Write a query to count the number of rows of a table in mysql.