SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
FROM table1
GROUP BY col1 )
Nishant Uppal
- 29
- 4