Editing SQL
Now all we need to do is add “TOP 3” to SELECT clause of our SQL query and recompile the class.
—TopFilms—
TopFilms
Query TopFilms() As %SQLQuery(CONTAINID = 1) { SELECT TOP 3 %ID,Description,Length,Rating,Title,Category->CategoryName FROM Film WHERE (PlayingNow = 1) ORDER BY TicketsSold DESC }
The TOP 3 statement indicates that we are only interesting in the first 3 rows returned by this query.