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

What is system tablespace?

1095


Explain self joins in oracle?

1017


How many anonymous blocks can be defined?

1184


Explain the use of grant option in exp command.

1063


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2178


Explain the use of analyse option in exp command.

1126


Explain about functional dependency and its relation with table design?

1008


How will you write a query to get a 5th rank student from a table student_report?

1866


What is a nested table?

1057


How to drop a stored function?

1137


What are set operators?

1082


What is redo log?

1064


Why is oracle used?

938


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

1091


What is oracle rowcount?

1084