please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / hamza tariq
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 the difference between sql and mysql and oracle?
How do I rename a table in mysql?
What is RMS Migrations
How to declare variable in mysql trigger?
what is the difference between the nvl function, ifnull function, and the isnull function? : Mysql dba
Can you tell what are various ways to create an index?
How do you stop an access query?
How will show all records containing the name "sonia" and the phone number '9876543210'
how to display nth highest salary from a table in a mysql query? : Mysql dba
How to display odd rows in student table in mysql?
What is append query?
How do I install and use mysql?
Why do we use views instead of tables?
can you elaborate on blob and text in mysql? : Mysql dba
How do I export mysql query results to excel?