How is the Query for 3 highest ranking values ?

Article View: borland.public.vdbase.data.sql

Article #86

Back to borland.public.vdbase.data.sql Previous Next

#86

From: M.E. Versteeg
Date: Thu, 09 Dec 1999 00:00

10 lines
872 bytes

I want to retrieve the 3 highest salaries on my SQL database.
Empno.   Salary
 (key)

How is the query for this?


It  would be appreciated, if anyone could send/post the query?

Caio!

Technical Details

Message-ID: <5NS34.3346$uG.44164@typhoon.chello.nl>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2f44db45d0350f29,start
X-Google-Attributes: gidff5a1,public
From: "M.E. Versteeg" <actofgod@chello.nl>
Subject: How is the Query for 3 highest  ranking values ?
Date: 1999/12/09
Message-ID: <5NS34.3346$uG.44164@typhoon.chello.nl>
X-Deja-AN: 558665220
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: newsmaster@chello.nl
X-Trace: typhoon.chello.nl 944765121 212.187.42.133 (Thu, 09 Dec 1999 19:45:21 MET)
Organization: "Chello Netherlands"
X-MSMail-Priority: Normal
NNTP-Posting-Date: Thu, 09 Dec 1999 19:45:21 MET
Newsgroups: borland.public.vdbase.data.sql