PostgreSql(Filtering & Sorting)
Filtering (WHERE clause) Filtering means → only certain rows are selected based on a condition. SELECT name, salary FROM Employee WHERE salary > 55000; Output: name salary Priya 60000 Meena 5800...
Source: DEV Community
Filtering (WHERE clause) Filtering means → only certain rows are selected based on a condition. SELECT name, salary FROM Employee WHERE salary > 55000; Output: name salary Priya 60000 Meena 58000 Arun 62000 Sorting (ORDER BY clause) Sorting means → arrange rows in ascending (ASC) or descending (DESC) order. SELECT name, salary FROM Employee ORDER BY salary DESC; See you soon in the next topic!.......
