how to get top 5 assets which having more tickets raised using sql
Posted on 2016-11-15
ticket table (ticket id,asset id(F.K),created time,customername,categoryid)
asset table (asset id,name,customername,categoryid)
if the asset(let suppose computer) having any issues one ticket will be created based on ticket support people vl give assistance.
i want top 5 assets which have more tickets got created.
can some one guide me form a query to get top 5 assets which having more tickets