select top 5 rows returned by particular query sql server

Question

Hi everybody , I want to retrieve top 5 rows returned by this query. How to do this

select COUNT(trippackageID), trippackageid 
from tbl_holiday_booking
group by trippackageID

Answer 1

select top 5 * from....

Answer 2

You Can use

limit 5

Answer 3

You are not specifying the order, do you want the package with the most bookings or the least?

SELECT TOP 5 COUNT(truppackageID) Num, trippackageid FROM tbl_holiday_booking GROUP BY trippackageID ORDER BY Num DESC 

Answer 4

select COUNT(trippackageID) as cnt, trippackageid from tbl_holiday_booking group by trippackageID ORDER BY cnt DESC LIMIT 0,5

Assuming you do, in fact, want to order by the count, descending (large to small). LIMIT 0,5 starts at row 0, and returns the next 5 rows.

Answer 5

SELECT COUNT(trippackageID) AS tpi_c, trippackageid 
  FROM tbl_holiday_booking 
  GROUP BY trippackageID 
  ORDER BY tpi_c DESC 
  LIMIT 5