hello

Monday, 27 August 2012

row number and rank in sql server

select top 100 RANK() over(order by cust_po_no) as pono, * from dbo.tbl_cust_po_mst



select top 100 Row_number() over(order by cust_po_no) as pono, * from dbo.tbl_cust_po_mst

No comments:

Post a Comment