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 / flitchner

select name from (select max(sal) as salary from emp) a,
emp b
where a.salary = b.sal;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176


Why use resource manager in Oracle?

1173


What are the uses of a database trigger?

1036


How to export several tables together?

1105


Is oracle a programming language?

1038


How to drop an index in oracle?

1120


What are the differences between date and timestamp in oracle?

1096


How to execute the package in oracle?

1135


What is oracle update statement with inner join ?

1115


Explain the use of record length option in exp command.

1118


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1984


How to define an anonymous block?

1246


How to view existing locks on the database?

1102


What are the differences between interval year to month and interval day to second?

1065


Design database draw er diagram for a certain scenario ?

4627