sql streng til visning af top ti film

SELECT TOP 10 Tabel1.nr, Tabel1.felt1, Tabel1.FELTNAVN FROM Tabel1
ORDER BY Tabel1.FELTNAVN DESC;

Du må jo have et felt der angiver hvilke film der ligger på TOP 10. Enten hvor mange gange de har været vist, eller et rent dubjektivt pointfelt. Herefter kan du bruge Select TOP:

SELECT TOP 10 Tabel1.POINT
FROM Tabel1
ORDER BY Tabel1.POINT DESC;

SELECT TOP 10 tblFilm.FilmID, Count(tblFilm.FilmID) AS CountSeen
FROM tblFilm
GROUP BY tblFilm.FilmID
ORDER BY Count(tblFilm.FilmID) DESC;

a little more information concerning your tables would be a GREAT help.
I am assuming that you have a table where there is one record for each time the film is seen, if you have a seperate table for that then mugs answer should be fine.

.

!

.

.