subquery, group by, order by

SELECT title, COUNT(1) FROM test_mst GROUP BY title; SELECT content, COUNT(1) FROM test_mst GROUP BY content; SELECT writer_id, COUNT(1) FROM test_mst GROUP BY writer_id; SELECT writer_id, COUNT(writer_id) FROM test_mst GROUP BY writer_id; SELECT *, (SELECT COUNT(1)FROM test_mst tm2 WHERE tm2.writer_id = tm.writer_id) FROM test_mst tm; SELECT tm.title AS '제목', tm.content AS '내용', tm.writer_id AS..

2022.12.13