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

Explain the insert into statements in sql?

1007


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1033


how many sql dml commands are supported by 'mysql'? : Sql dba

1123


How many parts of a pl sql block are optional?

1135


What is PL/SQL Records?

1190


Is id a reserved word in sql?

1145


how to get help information from the server? : Sql dba

941


How do I write a cron which will run a sql query and mail the results to agroup?

981


Explain what is a column in a table?

1107


Explain the uses of a database trigger?

1043


Can a foreign key have a different name?

940


What is over () in sql?

965


Why do we go for stored procedures?

1057


Is it possible to update views?

959


What does seeding a database mean?

968