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

select ename from employee where sal=(select disinct(max(sal) from employee));

Is This Answer Correct ?    2 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can Oracle users be audited?

1172


Please explain oracle left join with an example?

1095


What are the restrictions on external table columns?

1110


Explain the use of record length option in exp command.

1119


What is archive log in Oracle?

1184


20. Using a set operator, display the client number of all clients who have never placed an order.

2248


What is different types of joins?

1080


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2523


What is recovery manager(rman) backup in Oracle?

1231


Which are the five query types available in oracle?

1001


How do you bind variables in oracle?

1024


How to concatenate two text values in oracle?

1159


How to invoke the data pump import utility?

1229


How to specify default values in insert statement using oracle?

1155


What happens to the current transaction if the session is killed?

1039