Diff between rank & desnse_rank()

Hi ,
Just confused between the Yukon ranking functions
rank & dense_rank
Thanks
ARRSay you have following
Anderson
Anderson
Smith
Xing
Rank over these will give you 1, 1, 3, 4
Dense_rank will give you 1,1,2,3
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Aju" <ajuonline@.yahoo.com> wrote in message news:%23bE3v$$FFHA.3928@.TK2MSFTNGP15.phx.gbl...

> Hi ,
> Just confused between the Yukon ranking functions
> rank & dense_rank
> Thanks
> ARR
>