38 docs tagged with "sql"

Department Highest Salary

The Department Highest Salary problem involves finding the employees who have the highest salary in each department using joins and subqueries.

Department Top Three Salaries

The Department Top Three Salaries problem on LeetCode involves finding the top three unique earners in each department using window functions like DENSE_RANK().

Employees Earning More Than Their Managers

The Employees Earning More Than Their Managers problem on LeetCode involves finding employees whose salary is strictly greater than their manager's salary using a self-join.

Introduction to SQL

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

JSON Data in SQL

Handling JSON Data Within SQL.

Rising Temperature

The Rising Temperature problem on LeetCode involves finding all dates' Ids with higher temperatures compared to their previous dates (yesterday).

SQL Aggregate Functions

An aggregate function is a function that performs a calculation on a set of values, and returns a single value.

SQL Alias

The SQL Alias is used to give a table or a column a temporary name.

SQL ALTER TABLE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL AND Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL AVG() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL CASE Expression

The SQL CASE expression is used to add conditional logic to SQL queries.

SQL Cheatsheet

A fast, practical SQL reference for interviews, DBMS, and backend development.

SQL COUNT() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL CREATE DATABASE Statement

The SQL CREATE DATABASE statement is used to create a new database.

SQL CREATE TABLE Statement

The SQL CREATE TABLE statement is used to create a new table in the database.

SQL DELETE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL DROP DATABASE Statement

The SQL DROP DATABASE statement is used to delete an existing database.

SQL DROP Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL EXISTS Operator

The SQL EXISTS operator is used to check if a subquery returns any results.

SQL GROUP BY Statement

The SQL GROUP BY statement is used to group rows that have the same values in specified columns and apply aggregate functions.

SQL Having Clause

The `HAVING` clause in SQL is used to filter records in combination with the `GROUP BY` clause.

SQL INSERT INTO Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Joins

SQL Joins are used to combine rows from two or more tables based on a related column between them.

SQL LIKE Operator

The SQL LIKE operator is used to filter data based on patterns.

SQL Logical Operators

SQL logical operators are used to combine multiple conditions in a query.

SQL NOT Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL NULL Functions

SQL NULL functions are used to handle NULL values in SQL queries.

SQL OR Operator

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL ORDER BY

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL SELECT

The SELECT statement retrieves specific data from one or more tables in a database.

SQL SELECT TOP

The SQL SELECT TOP clause is used to limit the number of rows returned in a result set.

SQL Stored Procedures

SQL Stored Procedures are a set of SQL statements that can be stored and reused.

SQL SUM() Function

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Syntax

SQL statements are commands used to perform tasks such as querying, updating, and managing data in relational databases.

SQL UPDATE Statement

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.

SQL Views

SQL Views are virtual tables that represent a saved query in the database.

SQL WHERE Clause

SQL (Structured Query Language) is a standardized programming language for managing and manipulating relational databases.