Email: Password:       Forgot Password 
    .netCodeSG
A Saarsha Group Online Community for dot net codes group like C#, Asp.NET, VB.NET, Sharepoint, JavaScript, JQuery, Ajax, SQL, WCF, WPF.
 
TECHNOLOGIES:
How to generate row number in SQL Without ROWNUM...?

Posted On: 02/07/2013 11:30:18
SELECT FirstName, EmpSal, (SELECT COUNT(*)  FROM EMPLOYEE i WHERE o.FirstName >= i.FirstName) row_num
FROM EMPLOYEE o
order by row_num
MOST VIEWED QUESTION:
 
         HOME   |   Submit Article   |   Contact Us   |   About Us   |   Terms & Condition   |   Advertise With us