Select Top 40 Records 2

[RoguePoet01]

Hi,

Is there a way to select only 40 of the "Top" or "most recent" records in a query?

Thanks.

 

[sto]

Add this to your syntax SELECT TOP 40

 

[SQLBill]

As STO says, use the TOP 40 in your SELECT, but you also need an ORDER BY to show how the TOP 40 is to be selected.

example:

SELECT TOP 40 mydate,
              myname
FROM mydatabase
ORDER BY mydate ASC

That will return the TOP 40 earliest records.
Using ORDER BY mydate DESC will return the 40 latest (most recent) records.

-SQLBill

 

[RoguePoet01]

My thanks to both of you.