SQL Select the first x rows

Question

Possible Duplicate:
SQL Query to Select First/Top N records

Here is my code so far:

SELECT WeekNumber, SUM(Hours)
FROM Information
WHERE YEAR = 2011
GROUP BY WeekNumber
ORDER BY WeekNumber DESC

However; I am trying to select either the information for the last week, or the last month. Is there a way to select just the first row, or the first x rows, where those rows contain the hours for that month?

http://stackoverflow.com/questions/7680672/sql-query-to-select-first-top-n-records/7680733#7680733 is the answer for this question in multiple RDBMS — Adriano Carneiro, Oct 12 '11 at 15:29

score 3 · Accepted Answer · answered Oct 12 '11 at 15:27

3

Assuming you're using SQL Server, use the TOP clause (limit is only for MySQL); e.g.:

SELECT TOP 10 WeekNumber, SUM(Hours)
FROM Information 
WHERE YEAR = 2011
GROUP BY WeekNumber
ORDER BY WeekNumber DESC

answered Oct 12 '11 at 15:27

ChrisW

4,970
7
55
92

Is there a way to make the TOP clause dynamic, where it will change according to what week it is? – brachaalizah Oct 12 '11 at 15:30
@brachaalizah That makes no sense, weeknumber is potentially different for each row, the top x clause applies to the whole query – Adriano Carneiro Oct 12 '11 at 15:34

score 0 · Answer 2 · answered Oct 12 '11 at 15:27

Using Microsoft SQL Server 2008 (as specified in your tags), you need to use the TOP keyword.

SELECT TOP 10 WeekNumber, SUM(Hours)
FROM Information
WHERE YEAR = 2011
GROUP BY WeekNumber
ORDER BY WeekNumber DESC

The LIMIT keyword is for MySQL, not for SQL Server

You may also use SET ROWCOUNT 10 at the very start of your query, which does the same thing but will last for all subsequent queries in the connection.

SQL Select the first x rows

2 Answers2