SELECT
select all rows
# SQL
SELECT * FROM Person;
# Django ORM
persons = Person.objects.all()
for person in persons:
print(person.name)
print(person.gender)
print(person.age)
select 특정 column
# SQL
SELECT name, age FROM Person;
# Django ORM
Person.objects.only("name", "age")
select distinct rows (중복 제거)
# SQL
SELECT DISTINCT name, age FROM Person;
# Django ORM
Person.objects.values("name", "age").distinct()
specific number of rows
# SQL
SELECT * FROM Person LIMIT 10;
# Django ORM
Person.objects.all()[:10]
LIMIT AND OFFSET
# SQL
SELECT * FROM Person OFFSET 5 LIMIT 5;
# Django ORM
Person.objects.all()[5:10]