Home » MCQs » SQLAlchemy MCQs

Which of the following is the correct syntax to sort the names in ascending order?

23. Which of the following is the correct syntax to sort the names in ascending order?

1. pool = select([students]).order_by.asc(students.c.name)
2. pool = select([students]).asc(students.c.name)
3. pool = select([students]).where(asc(students.c.name))
4. pool = select([students]).order_by(asc(students.c.name))

Answer: D) pool = select([students]).order_by(asc(students.c.name))

Explanation:

The correct syntax to sort the names in ascending order is:

pool = select([students]).order_by(asc(students.c.name))