tag:blogger.com,1999:blog-495177919198719500.post6893047249066449056..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: RANK() VS DENSE_RANK() With an Example using SQL Server 2005/2008Suprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-495177919198719500.post-79424676134511930692018-05-15T20:39:08.285-07:002018-05-15T20:39:08.285-07:00Helpful... nicely explainedHelpful... nicely explainedAditya Ghoshhttps://www.blogger.com/profile/02901885479020803340noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-42906443814166944902016-05-11T21:55:49.448-07:002016-05-11T21:55:49.448-07:00How to count the rank only once in the above query...How to count the rank only once in the above query?Anonymoushttps://www.blogger.com/profile/12939593620508494045noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-68529783338505907642013-11-20T07:31:13.486-08:002013-11-20T07:31:13.486-08:00Thanks a lot for your article. It was so easy to u...Thanks a lot for your article. It was so easy to understand and explained the difference clearly.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-78165929710559781812013-09-29T13:40:08.896-07:002013-09-29T13:40:08.896-07:00Simple and good expanationSimple and good expanationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-75070920623276302872012-12-18T01:31:37.033-08:002012-12-18T01:31:37.033-08:00good job thanks lotgood job thanks lotAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-37918477883461520522011-10-01T02:21:03.896-07:002011-10-01T02:21:03.896-07:00Very good article.
See the Rank() and DENSE_RANK(...Very good article.<br /><br />See the Rank() and DENSE_RANK() functions examples with following link<br />http://www.besttechtools.com/SQLArticles.aspx?ID=RankAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-5907028133500988852011-07-07T14:27:27.787-07:002011-07-07T14:27:27.787-07:00Nice explanation of rank() vs. dense_rank(). Thank...Nice explanation of rank() vs. dense_rank(). Thanks!Jay Philip Williamshttps://www.blogger.com/profile/06345224230392616406noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-15561541802850202322010-02-03T06:38:28.372-08:002010-02-03T06:38:28.372-08:00Here is an article about multiple usages of Row_nu...Here is an article about multiple usages of Row_number() function<br /><br />http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/multipurpose-row-number-function.aspx<br /><br />MadhivananUnknownhttps://www.blogger.com/profile/13241916831072779717noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-43448816684031464462009-07-26T22:29:24.047-07:002009-07-26T22:29:24.047-07:00hatic: Seems you got your answer here. Sharing the...hatic: Seems you got your answer here. Sharing the link for benefit of readers <br /><a href="http://www.eggheadcafe.com/conversation.aspx?messageid=34757793&threadid=34757790" rel="nofollow">http://www.eggheadcafe.com/conversation.aspx?messageid=34757793&threadid=34757790</a>Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-71253945014566639332009-07-22T06:00:28.775-07:002009-07-22T06:00:28.775-07:00yes, MS Access 2003yes, MS Access 2003hatichttps://www.blogger.com/profile/11224288551374489274noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-90454784658395488222009-07-22T03:40:26.511-07:002009-07-22T03:40:26.511-07:00access sql? You mean MSAccess?access sql? You mean MSAccess?Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-14808998383798362322009-07-21T10:44:00.784-07:002009-07-21T10:44:00.784-07:00Hi,
How can I convert these two rows to access sql...Hi,<br />How can I convert these two rows to access sql?<br /><br />dense_rank() over(partition by field1 order by field2) as name1,<br /><br />row_number() over(partition by fld1, (dense_rank() over(partition by fldnm1 order by fldnm2)) order by fld2) as name2<br /><br />thanks in advancehatichttps://www.blogger.com/profile/11224288551374489274noreply@blogger.com