This is my technical area for troubleshooting and learning new programming skills and much more. Here, you will find answers on a wide range of technologies such as AI, Machine Learning, OpenAI, Databricks, ASP.NET, C#, Python, Microsoft Access, MySQL, Amazon Web Services, SQL Server, PL/SQL, JD Edwards, SAS, Salesforce, APIs, MVC, and many others. Please feel free to visit and join the discussion!
Thursday, July 28, 2011
get Row number group by SQL-Server
select
payroll_item,[name],Row_number() OVER(PARTITION BY payroll_item ORDER BY payroll_item) AS 'OBJ_Detail' from Tempprdetail
No comments:
Post a Comment