|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
April 11th, 2003, 03:23 AM
|
|||
|
|||
|
ok try this<br><br><br>SELECT MAX(salary) AS Expr1 FROM employee WHERE <br>(salary NOT IN ((SELECT MAX(salary) AS Expr1 FROM employee<br> WHERE (salary NOT IN (SELECT MAX(salary) AS Expr1 FROM employee))),<br> (SELECT MAX(salary) AS Expr1 FROM employee)))<p><hr size="1" width="50%" align="left" />(#_#)</p>
|
|
#3
October 8th, 2003, 06:39 AM
|
|||
|
|||
|
Either with
SET ROWCOUNT 3 OR SELECT TOP 3 SELECT blabla FROM blabla WHERE blabla ORDER BY salary DESC Then jump to the last line (MoveLast?)
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Select Query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
