dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Difference Between RANK, DENSE_RANK and ROW_NUMBER SQL Statements

Learn more about how to use three very different SQL statements.


advertisement

Learn more about how to use three very different SQL statements.

  • ROW_NUMBER Always generates unique values without any gaps.
  • RANK  Has gaps in its sequence
  • DENSE_RANK  Returns the same rank for ties, but doesn’t contain any gaps

 

Visit the DevX Tip Bank

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date