Hent kun de første 5 poster i access db

SQL = "SELECT TOP 5 * FROM tabel order by id DESC"
set rs = conn.execute(SQL)
do while not rs.eof
response.write rs("id") & "<BR>"
rs.movenext
loop
rs.close
set rs = nothing
conn.close
set conn = nothing


/Goose

Ovenstående er de 5 nyeste poster, hvis det er de 5 første skal det være:

SQL = "SELECT TOP 5 * FROM tabel order by id"
set rs = conn.execute(SQL)
do while not rs.eof
response.write rs("id") & "<BR>"
rs.movenext
loop
rs.close
set rs = nothing
conn.close
set conn = nothing

/Goose