View Single Post
  #3 (permalink)  
Old March 25th, 2008, 02:52 PM
crabjoe crabjoe is offline
Authorized User
Points: 254, Level: 5
Points: 254, Level: 5 Points: 254, Level: 5 Points: 254, Level: 5
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2007
Location: , , .
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It only give me the Top 10.

Here's what I'm trying to get, but lets use Top 3

MONTH NAME SAVINGS
200801 JOHN 500
200801 MIKE 250
200801 JANE 50
200802 JOHN 500
200802 SHANE 400
200802 MIKE 350
200803 JANE 700
200803 JOHN 500
200803 MARK 200

The problem is, when I do:
select top 3 from T_SAVINGS order by SAVING

MONTH NAME SAVINGS
200803 JANE 700
200803 JOHN 500
200802 JOHN 500

What I'm trying to do is get the 1st set of results without having to do a query for every month and doing unions.

Thanks





Reply With Quote