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 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!.......