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 select the name of employee who is getting maximum
sal with out using subquery

Answer Posted / mk

select Name from emp where sal=(select distinct(Max(sal))
from emp

Is This Answer Correct ?    4 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to delete a column in an existing table?

1059


What do you mean by a database transaction & what all tcl statements are available in oracle?

971


What is a package ? What are the advantages of package ?

1071


What is the quickest way to export a table to a flat file?

952


HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.

1404


Respected sir, Please send me technical questions related to oracle apps..

1791


What are a collation and state the different types of collation sensitivity?

1149


How can I introduce multiple conditions in like operator?

970


In which language oracle has been developed?

1052


What is an oracle cursor variable?

1046


Explain an integrity constrains?

1121


How to call a sub procedure?

1074


How to drop a stored function?

1124


How to select an oracle system id (sid)?

1047


What is an oracle and why it is used?

1128