Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to find out the second largest element from mysql table

Answer Posted / lekhraj deshmukh

select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;

Is This Answer Correct ?    21 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which is faster mongodb or mysql?

849


How many types of indexes are there in mysql?

865


What is a select query?

816


Explain triggers and stored procedures?

879


What is ndb in mysql?

911


Explain the different types of mysql joins.

866


List some comparisons operators used in mysql?

944


What are the types of queries?

904


How does mysql store data?

887


What is the difference between heap table and temporary table?

1071


What is mysql_pconnect?

849


How can you find out the version of the installed mysql?

1251


Where is mysql password stored?

886


How can we run batch mode in mysql?

1005


What are mysql queries?

884