Skip to content

Main Navigation

👾 Csharp Design Patterns

😅 JavaScript

🤯 TypeScript

😎 Unsafe CSharp

🐫 Regular Expression

🗿 Entity Framework Core

😬 HTML & CSS

🐚 Powershell

Appearance

Sidebar Navigation

SQL

Complex Query

ALL and ANY

Correlated subqueries

EXISTS

Subquery

Data Types

Data Types

Designing Database

Normal Forms

Essenitial Functions

Functions

Inserting, Updating, and Deleting Data

Create a Copy of a Table

Deleting Records

Inserting Records

Update Records

Retrieving Data From Multiple Tables

CROSS JOIN Clause

INNER JOIN Clause

NATURAL JOIN Clause

OUTER JOIN Clause

UNION Operator

USING Clause

Retrieving Data From Single Table

LIMIT clause

ORDER BY clause

Operators

SELECT Statement

Stored Procedures and Stored Functions

Basic Function Syntax

Basic Procedure Syntax

Control Flow Statements

Define a Variable

OUT Modifier

Raise Exception in SQL

Value Assignment

Summarizing Data

Aggregate Functions

The GROUP BY Clause

The HAVING Clause

Transactions

Transaction Isolation Levels

Transactions

View

View

On this page

Deleting Records

Delete All Records

sql

DELETE FROM [table]

1

Using sub query

sql

DELETE FROM [table]
WHERE [column] IN [sub_query]

1
2

Edit this page on GitHub

Last updated:

Pager

Previous pageCreate a Copy of a Table

Next pageInserting Records

Copyright © 2023-present @sharpchen
Powered by VitePress - 1.3.3