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 / girija.112

Answer Posted / girija.112

ANS :
select max(ename) keep (dense_rank last order by sal) ename
from emp

ENAME
-----
KING

Is This Answer Correct ?    8 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an anonymous block?

1188

What is oracle and what are its different editions?

1040

How to rename a tablespace in oracle?

1061

How to use like conditions in oracle?

1016

How to export data with a field delimiter?

990

How to create an oracle testing table?

1026

What is an index associated with a constraint?

998

Explain oracle data types with examples?

990

What are the different windows events activated at runtime ?

2858

What is BBED in Oracle?

1119

Explain view?

1002

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2196

What is ceil and floor in oracle?

1037

When do we use group by clause in a sql query?

1009

How do I spool to a csv formatted file using sqlplus?

990