How to find out the second largest element from mysql table
Answer Posted / salil
SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);
Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
Does mysql use sql?
What is a string in mysql?
Where the database is stored in mysql?
Can you tell which of the following where clauses is faster?
In which year mysql created?
What is 'mysqld'?
Can mysql handle big data?
How many TRIGGERS are allowed in MySql table?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
What is difference between mysql and mysql workbench?
What is mysql cursor?
How do I edit a trigger in mysql?
What is blob in mysql?
Why to use char instead of varchar in the database?