How to get the maximum value

Other SQL Server Topics
1

Hi all,
how to get the maximum value on this query??

select c.cat_name, count(r.cat_id) as Crime_No
from reports r
join categories c
on r.cat_id = c.cat_id
group by c.cat_name
order by 2 desc

2

select top (1) c.cat_name, count(r.cat_id) as Crime_No
from reports r
join categories c
on r.cat_id = c.cat_id
group by c.cat_name
order by 2 desc

1 Like
3

Thanks for the community answer. I have resolved the issue using the above commands.

4

thanks Scott for the answer.
I tried the query but I got an error.

ORA-00923: FROM keyword not found where expected

5

This is a microsoft sql server forum

6

select c.cat_name, count(r.cat_id) as Crime_No
from reports r
join categories c
on r.cat_id = c.cat_id
group by c.cat_name
order by 2 desc
fetch first 1 rows only;