Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
 Posted - 2010-03-03 : 01:52:33
|
| Hi,Be honest,i gotta stuck of using the Ranking Functions..hope there are 4 below ranking functions are available..<b> RANKING Functions:</b>1.ROW_NUMBER,2. RANK,3. DENSE_RANK,4. NTILEcould you please explain me with the sample code of above functions.. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-03-03 : 02:04:47
|
| Just google ranking functions SQL 2005.You get a hell lot of articles explaining the same.PBUH |
 |
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2010-03-03 : 02:11:19
|
| http://www.databasejournal.com/features/mssql/article.php/3661461/New-Ranking-Functions-within-SQL-Server-2005.htm |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-03-03 : 02:41:49
|
| SQL Server help file also has examplesMadhivananFailing to plan is Planning to fail |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-03-03 : 03:12:53
|
quote:
Originally posted by madhivanan
SQL Server help file also has examplesMadhivananFailing to plan is Planning to fail
Thanks madhi.could i ask,where can i find this? |
|
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-03-03 : 03:24:51
|
quote:
Originally posted by haroon2k9
quote:
Originally posted by madhivanan
SQL Server help file also has examplesMadhivananFailing to plan is Planning to fail
Thanks madhi.could i ask,where can i find this?
Type "Ranking Functions (Transact-SQL)" in Books online "Look for " text box (Assuming that books online is installed on your system ).The page will have sample example. |
|
|
|
haroon2k9
Constraint Violating Yak Guru
328 Posts |
Posted - 2010-03-03 : 03:32:40
|
quote:
Originally posted by pk_bohra
quote:
Originally posted by haroon2k9
quote:
Originally posted by madhivanan
SQL Server help file also has examplesMadhivananFailing to plan is Planning to fail
Thanks madhi.could i ask,where can i find this?
Type "Ranking Functions (Transact-SQL)" in Books online "Look for " text box (Assuming that books online is installed on your system ).The page will have sample example.
Okay..Got it..Thanks to u and all.Let me have a look at it,any doubts / confusion,again post it here..hope u all help me out.Thanks Again |
|
|
|
abhit_kumar
Posting Yak Master
147 Posts |
Posted - 2010-03-03 : 04:51:22
|
| use GOOGLE...its best for any type of detailed explanation on any type of topic. |
|
|
|
|
|
|
Ranking Functions!!!!