View Single Post
  #3 (permalink)  
Old December 4th, 2003, 04:12 PM
Jeff Mason Jeff Mason is offline
Friend of Wrox
 
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post
Default

Can't quite parse your requirement. Do you mean you want the set of rows whose 'Sal' value is in the top 1/3 of all 'Sal' values? If your database implements the TOP clause (e.g. SQL Server) you could use:
Code:
SELECT TOP 33.3 PERCENT * FROM yourtable ORDER BY Sal DESC;
Jeff Mason
Custom Apps, Inc.
www.custom-apps.com