_________________________________
| id | error_number | error_desc |
SELECT TOP (100)
[error_number] ,
COUNT([error_number])as total
FROM Db.tab_error
group by error_number
error_desc
? SELECT TOP (100)
[error_number] ,
[error_desc],
COUNT([error_number])as total
FROM Db.tab_error
group by error_number, error_desc
SELECT TOP (100)
[error_number] ,
[error_desc],
COUNT(*) over (partition by [error_number]) as total
FROM Db.tab_error