POSTGRESQL DATABASE INTERVIEW QUESTIONS

What is the purpose of the ORDER BY clause in PostgreSQL?

How do you sort the results of a query in descending order using ORDER BY in PostgreSQL?

Can you sort query results by multiple columns using ORDER BY in PostgreSQL?

What happens if the ORDER BY clause contains columns that are not part of the SELECT statement in PostgreSQL?

Explain how NULL values are handled in sorting when using the ORDER BY clause in PostgreSQL.

How can you perform a case-insensitive sort using the ORDER BY clause in PostgreSQL?

What are the performance implications of using the ORDER BY clause in large datasets in PostgreSQL?

Describe how the ORDER BY clause interacts with window functions in PostgreSQL.

How can you use the ORDER BY clause in conjunction with the FETCH clause to limit results in PostgreSQL?

In a complex query involving multiple JOINs, GROUP BY, and ORDER BY clauses, explain the execution order of these clauses in PostgreSQL.