How to find out the second largest element from mysql table
- 15 Answers
- 25951 Views
- I also Faced
- E-Mail Answers
Answer Posted / prashant chaudhary
select name,marks from Student_Info where marks = (select
max(marks) from Student_Info where marks <
(select max(marks)from Student_Info ))
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What do you mean by % and _ in the LIKE statement?
What does tinyint mean?
How do I select a database in mysql?
What are the functions in mysql?
Is null in mysql?
How do I restart mysql on windows?
Is mysql free for enterprise?
In which language mysql has been written?
What is mysql enterprise edition?
How internally data stores in MyISAM and INNODB table types?
How set mysql root password?
Can you tell what are various ways to create an index?
What are mysql data types?
What is query log in mysql?
How do I grant privileges to a user in mysql phpmyadmin?
