Recovery
Labels
.NET
(42)
Server
(22)
Social
(9)
Virtual Machine
(2)
Pages
Home
Monday, August 27, 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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment