5위까지 카운트된 값출력 쿼리
select first 5 seq_num, count(seq_num) as cnt from meeting_seminar_sub group by seq_num order by 2 desc
ex)
seq_num cnt
132 12
70 10
170 9
186 7
188 7
SQL/informix
5위까지 카운트된 값출력 쿼리
select first 5 seq_num, count(seq_num) as cnt from meeting_seminar_sub group by seq_num order by 2 desc
ex)
seq_num cnt
132 12
70 10
170 9
186 7
188 7