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 / sudeep mishra

select *
from employee
where salary = max sal

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by <> in sql?

1029


Can we insert data into materialized view?

993


What is the most important ddl statements in sql are?

1042


What is rename command in sql?

1093


How to test for null values?

1098


What is cte?

1025


How can I delete duplicate rows?

1063


Why we use join in sql?

1026


how can you see all indexes defined for a table? : Sql dba

1053


Why do we use joins in sql?

1008


What is dense_rank?

989


What are the properties of a transaction?

1185


Can procedure in package be overloaded?

1144


i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4099


Is pl sql still used?

1018