SQL problem

From: <lasttrap_at_qatar.net.qa>
Date: Sat, 27 Jun 1998 13:47:01 GMT
Message-ID: <6n2t4m$q4f$1_at_nnrp1.dejanews.com>

[Quoted] I need To Find The first 3 highest salary in emp table without replication. EX :
this is the table Emp (empno,ename,sal)

Ename          Sal
 a                  5000
b                    7000
c                    2000
d                    5000
e                     1500
f                      1000
m                     2500
n                      5000
I need to have This result :
Ename              Sal
b                       7000
a                       5000
m                       2500

can any one help me please .

[Quoted] -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jun 27 1998 - 15:47:01 CEST