mySQL

mySQL 기초적 코드들..

bunbun2 2022. 11. 3. 18:40
select * from orders
where payment_method != 'CARD';

select * from point_users
where point between 20000 and 30001;

select * from users
where email like 's%com' and name like '이%';

select distinct(payment_method) from orders
limit 5;

select count(*) from orders
where payment_method = 'kakaopay';

select count(distinct(name)) from users