0% found this document useful (0 votes)
4 views27 pages

SQL Commands

The document outlines various SQL commands and operations, including table creation, data insertion, and methods for handling duplicates. It also covers SQL operators, joins, functions, and advanced topics like triggers and indexing. Overall, it serves as a comprehensive guide to SQL functionalities and best practices.

Uploaded by

jayantgupta28110
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
4 views27 pages

SQL Commands

The document outlines various SQL commands and operations, including table creation, data insertion, and methods for handling duplicates. It also covers SQL operators, joins, functions, and advanced topics like triggers and indexing. Overall, it serves as a comprehensive guide to SQL functionalities and best practices.

Uploaded by

jayantgupta28110
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 27

SQL

Vishnu
Create Table

Insert Values
SQL
Vishnu

Identify Duplicates Values

Delete The Duplicates


SQL
Vishnu
SQL Operator

Comparision Operator
SQL
Vishnu
Logical Operator

SQL Expressions
SQL
Vishnu
Drop Table

Delete Table

Truncate Table empty the table

SQL Alter Table

SQL Reaname Table


SQL
Vishnu
Select

Distinct

Count

Limit

Order By
SQL
Vishnu
Select Random

Sum

Select Null

Where Clause

Update
SQL
Vishnu
And

Or

As

like

Order by asc

Order by desc
SQL
Vishnu
Order by/random

Order By Multiple

Delete

Add Column
SQL
Vishnu
Modif y

Drop

Default
SQL
Vishnu
SQL JOIN
SQL
Vishnu
Inner Join

Left Join

Right Join
SQL
Vishnu
Full Outer Join

Cross Join
SQL
Vishnu
Create Table

Insert Values
SQL
Vishnu
Group By /Order By

Between

Where

Having/Group by
SQL
Vishnu
Delete

Subqueries
Select

Insert
SQL
Vishnu
Correct PostgreSQL Example (User-Defined Function)

Insert

Function to check bonus


SQL
Vishnu

Function In Query

SQL Cast & Convert Function

Autocommit
SQL
Vishnu
Update

Rollback

SQL LIKE AND WILDCARDSCHARACTERS

Percent
SQL
Vishnu
Underscore

how to find the nth highest salary in sql

Dense Rank

View as
SQL
Vishnu
how to delete duplicates rows in the sql

Delete

Row Number

Delete Duplicates
SQL
Vishnu
pattern matching in sql-
Like %

Like last%

Underscore

SQL TRIGGERS

Trigger Function
SQL
Vishnu
Trigger

After Insert Create log table

Trigger Function
SQL
Vishnu
Before Update

Trigger Function
SQL
Vishnu
Serial

how to create index in sql


SQL
Vishnu
Regex

SQL CTE
FOLLOW

VISHNU VARDHAN

You might also like