#sql
22 topics
Computer Science
CASE WHEN: Conditional Expressions in SQLCollegeCOALESCE and NULLIF: NULL Handling FunctionsCollegeCommon Table Expressions (CTEs): WITH ClauseCollegeDELETE Statements: Removing Rows with ConditionsCollegeDISTINCT: Eliminating Duplicate RowsCollegeLAG, LEAD, and OFFSET: Accessing Rows in WindowsCollegeRanking Functions: ROW_NUMBER, RANK, DENSE_RANKCollegeSQL Aggregation and GROUP BYCollegeSQL JoinsCollegeSQL Subqueries and CTEsCollegeSQL Views and Materialized ViewsCollegeSQL: ALTER TABLE and Schema ModificationCollegeSQL: Constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, DEFAULT)CollegeSQL: Creating and Modifying TablesCollegeSQL: INSERT, UPDATE, and DELETE (DML)CollegeSQL: OUTER JOINs (LEFT, RIGHT, FULL)CollegeSQL: SELECT Statement and Basic QueriesCollegeSQL: Set Operations (UNION, INTERSECT, EXCEPT)CollegeSQL: Sorting, Limiting, and PaginationCollegeSQL: WHERE Clause and FilteringCollegeUPDATE with JOINs: Conditional UpdatesCollegeWindow Functions: Analytical QueriesCollege