Interview Questions Answers in Oracle General

niladri chatterjee

{ City } phoenix
< Country > usa
* Profession *
User No # 88916

Total Questions Posted # 1
Total Answers Posted # 1

Total Answers Posted for My Questions # 4
Total Views for My Questions # 8240

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { niladri chatterjee }

Questions Answers Category Views Company eMail

Q) How to Find Max Date from each Group? (Asked in Infosys (INFI)Interview)

Infosys,

4 Oracle General 8240

Answers / { niladri chatterjee }

Question { 15458 }

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

Answer

Select * From (Select * From Employee Order By Salary Desc) a
Where rownum=1 ;

Or

Select * From (Select Emp_id, Emp_NM, Salary From Employee Order By Salary Desc) a
Where rownum=1 ;

Based on Oracle 11g.

Is This Answer Correct ?

0 Yes

0 No