[MySQL] group by
create table test2( userid varchar(20) not null, name varchar(20) not null, gender enum('남자', '여자'), point int default 0 ); insert into test2 values('apple', '김사과', '여자', 1000); insert into test2 values('banana', '반하나', '여자', 500); insert into test2 values('orange', '오렌지', '여자', 1600); insert into test2 values('melon', '이메론', '남자', 700); insert into test2 values('avocado', '안카도', '남자', 1200); in..
MySQL
2023. 3. 20. 22:17