MySQL - 중복제거 distinct, 정렬 order by

select * from books;

 

중복을 제거하기 distinct

 

select distinct author_lname
from books;

 

 

 

정렬하기 order by

 

-- author_lname 으로 정렬
select *
from books
order by author_lname;

 

-- full_name 으로 정렬(SQL 동작 방식을 이해)
select id, title, concat(author_fname, ' ', author_lname) as full_name,
       released_year, stock_quantity, pages
from books
order by full_name;

 

-- full_name 내림차순으로 정렬(desc), 오름차순은 아무것도 쓰지 않거나 asc
select id, title, concat(author_fname, ' ', author_lname) as full_name,
       released_year, stock_quantity, pages
from books
order by full_name desc;