pluk de 4 højeste tal ud

SELECT TOP 4 FROM YourTable ORDER BY TalFelt DESC

SELECT TOP 4 * FROM YourTable ORDER BY TalFelt DESC

Hvad så hvis jeg f.eks skal have den 5. højeste til den 8. højeste?

SELECT TOP 3 * FROM DinTabel WHERE ID<>(SELECT TOP 5 ID FROM dintabel) ORDER BY Talfelt DESC.

Thats another question isnt it :o)

If you have an ID (autonumber) in the table then overchords will work I think (not tested :o) ) but if you only have the tal field then I think this might work.

NOTE: This gives you the 5th to the 8th heighest (4 records) and ID is the tal field

SELECT TOP 4 * FROM Tabel WHERE ID NOT IN  (SELECT TOP 4 ID FROM tabel ORDER BY ID DESC) ORDER BY ID DESC

can you use these answers Lars?

Lars, I notice you have a couple of old open questions for over 400 points. If you arent happy with the help you received then you could place an answer yourself and get the points back :o)

Sorry, i've been away for a couple of days. Hop it's allright. Thank for your help

no problem at all Lars!