I would like to share my knowledge
and open to recieve knowledge from
others.
Friday, 9 November 2012
How to get the record of highest saleried Employee in sql?
--How to get the record of highest saleried Employee SELECT * FROM ( SELECT DENSE_RANK() OVER(ORDER BY [Salery] DESC)AS RowId, * FROM EmployeeRecord ) AS e1 WHERE e1.RowId = 4
No comments:
Post a Comment