Skip to content

sql.md

Latest commit

 

History

History
29 lines (19 loc) · 795 Bytes

sql.md

File metadata and controls

29 lines (19 loc) · 795 Bytes

Junior-2 Sql level

The Postgresql DBMS dialect
  • ORDER BY

  • What is an ORDER BY and what is it used for?

  • What types of ORDER BY sorting exist?

  • LIMIT and OFFSET

  • What is the LIMIT?

  • What is the OFFSET?

  • Give an example of how LIMIT and OFFSET can be used.

Tasks

  • Write an sql script that will pick up all users and sort them by id and creation time (descending sort), the script should pick up only 5 users. Table schema:
      user table
 ________________________________
| id | email | created_at | name |

Resources