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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

How to select the name of employee who is getting maximum
sal with out using subquery

Question Posted / rohit

Answer Posted / rohit

SELECT ENAME,SAL FROM EMP
WHERE ROWNUM = 1
ORDER BY SAL DESC

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to pass a cursor variable to a procedure?

1114

Explain how you would restore a database using RMAN to Point in Time?

2149

How data locks are respected in oracle?

1073

What is the data pump export utility?

1087

what is the difference between data migration and production migration.

2350

How to pass parameters to procedures?

1039

State and explain about oracle instance?

1001

Give the various rollback segment states.

1055

What is backup in Oracle?

1008

What is a select query statement in oracle?

972

How to define an anonymous procedure with variables?

1165

How to convert times to characters in oracle?

1027

How does oracle handle read consistency?

1102

What are triggers in oracle?

1043

How to divide query output into groups in oracle?

994