FETCH ALL ROW IN SQL
SELECT *
FROM Person;

FETCH ALL ROW IN DJANGO

Person.objects.all()
      
-----Example print in django----
persons = Person.objects.all()
      
for person in persons:
   print(person.name)
   print(person.gender)
   print(person.age)
FETCH SPECIFIC COLUMNS IN SQL
SELECT name, age
FROM Person;

FETCH SPECIFIC COLUMNS IN DJANGO

Person.objects.only('name', 'age')
FETCH DISTINCT ROWS IN SQL
SELECT DISTINCT name, age
FROM Person;

FETCH DISTINCT ROWS IN DJANGO

Person.objects.values('name', 'age').distinct()
FETCH SPECIFIC NUMBER OF ROWS IN SQL
SELECT *
FROM Person
LIMIT 10;

FETCH SPECIFIC NUMBER OF ROWS IN DJANGO

Person.objects.all()[:10]
LIMIT AND OFFSET KEYWORDS IN SQL
SELECT *
FROM Person
OFFSET 5
LIMIT 5;

LIMIT AND OFFSET KEYWORDS IN DJANGO

Person.objects.all()[5:10]
Prev next