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 # 6921

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 6921



Answers / { niladri chatterjee }

Question { 12138 }

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