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...

write a query to Find the Maximun second value in table?

Answer Posted / ruchi

you can use following query
select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why are databases so important?

946


What is concept of dbms?

914


How do you create a database?

914


What are service-specific middleware?

997


How do you call a stored procedure from jdbc?

942


Can we linked SharePoint to a SQL databasebe?

1103


How many types of database language exist?

1043


What is a foreign key constraint?

1018


What is hot backup (in case of oracle)?

928


what are the different integrity rules present in the dbms?

982


What is the best way to determine whether firebird server is running?

1069


What are the various types of relationships in database? Define them.

895


What is procedure in dbms?

890


Is database a storage?

896


What is advantages of progress actional?

919