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

From an Employee table, how will you display the record
which has a maximum salary?

Answer Posted / anil

select * from test.emp where salary=(select max(salary) from test.emp);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I view a view in sql?

957


What is character functions?

1066


What is the difference between delete and truncate commands?

1050


What does inner join mean?

1182


What are stored procedures used for?

1010


What does desc stand for?

1076


What is meant by truncate in sql?

1074


Explain the difference between drop and truncate commands in sql?

1067


Is sql difficult?

1165


Does view contain data?

1041


How is indexing done in search engines?

986


What is a system versioned table?

998


Explain how exception handling is done in advance pl/sql?

1004


What pl/sql package consists of?

1091


What are different categories of sql commands?

1137