Plagiarised spam would be article Reposted ("Basic & Advanced Q's of MS-SQL queries", Member 13199023)
-
I'm revising my vote! I originally went for "Extremely poor quality", but then I remembered that "Interview Q&A" articles are normally "written" by people who have no idea about the subject. So I thought "I wonder if it's stolen?". Basic & Advanced Q's of MS-SQL queries [^] From: Member 13199023 - Professional Profile[^] Basic & Advanced Q's of MS-SQL queri[^] Check this: Difference between row_number(), rank() and dense_rank() in SQL Server, Oracle.[^] And search both for:
Quote:
Rank() function will assign the same rank to same values i.e. which are not distinguishable by ORDER BY. Also, the next different rank will not start from immediately next number but there will be gap i.e. if 4th and 5th
Then keep reading ...
Sent from my Amstrad PC 1640 Never throw anything away, Griff Bad command or file name. Bad, bad command! Sit! Stay! Staaaay... AntiTwitter: @DalekDave is now a follower!
