How to find out the second largest element from mysql table
Answer Posted / prashant chaudhary
select top 1 * from ( select top 3 * from Student_Info
order by marks desc)table1 order by marks
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Which is faster mongodb or mysql?
What is select query in mysql?
What does mysql_query return?
What is ISAM?
How to delete an existing column in a table?
What language does mysql use?
What is heap table?
What is indexing in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
Can we rename database in mysql?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
how to add a new column to an existing table?
Is mysql a odbc?
How do I change global variables in mysql?
How do I fix a crashed mysql database?