I need a query that returns every n record from the database and the last record.
For every n-th is easy, but I need a
WHERE Index % n = 0
but I need a last one too.
Any Help.
How about a UNION statement? The new code you want is in green.
SELECT Col1, idx
FROM MyTable
WHERE idx % 12 = 0
UNION
SELECT Col1, idx
FROM MyTable
WHERE idx = (SELECT MAX(idx) FROM MyTable)
|||In 2005, you can do something like:
select *
from (
select row_number() over (order by object_id) as rowNum,
object_id
from sys.objects
) as objects
where rowNum % 5 = 0
or rowNum = (select count(*) from sys.objects)
There is a (more messy) way to do it in 2000 also. The key is that tables don't have order, so you will need to define an order in order to calculate N.
No comments:
Post a Comment