Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!t-online.de!inka.de!rz.uni-karlsruhe.de!feed.news.schlund.de!schlund.de!news.online.de!not-for-mail
From: Dieter Noeth <dnoeth@gmx.de>
Newsgroups: comp.databases.theory
Subject: Re: Can I do this using SQL?
Date: Fri, 10 Feb 2006 13:14:37 +0100
Organization: 1&1 Internet AG
Lines: 8
Message-ID: <dsi04m$lmf$1@online.de>
References: <1139486157.184995.202500@g43g2000cwa.googlegroups.com> <1139540128.434166.136380@g44g2000cwa.googlegroups.com> <dshilm$6p0$1$8302bc10@news.demon.co.uk> <dshleb$ml8$1@online.de> <Ksqdnf7S2P14xnHenZ2dnUVZ8qednZ2d@pipex.net> <dshvq9$lco$1@online.de>
NNTP-Posting-Host: p549b8625.dip0.t-ipconnect.de
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: online.de 1139573718 22223 84.155.134.37 (10 Feb 2006 12:15:18 GMT)
X-Complaints-To: abuse@einsundeins.com
NNTP-Posting-Date: Fri, 10 Feb 2006 12:15:18 +0000 (UTC)
User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716)
X-Accept-Language: de-DE, de, en-us, en
In-Reply-To: <dshvq9$lco$1@online.de>
Xref: dp-news.maxwell.syr.edu comp.databases.theory:35953

Dieter Noeth wrote:

> ROW_NUMBER -> exactly 10 rows
> RANK -> then rows plus all the rows with the same value as the 10th.

RANK -> ten rows plus all the rows with the same value as the 10th.

> DENSE_RANK -> all the rows with the 10 highest distinct values