Tafarki koyarwa

Tajriba koyarwa SQL ta baya

• SQL Tutorial
• SQL Introduction
• SQL Syntax
• SQL select
• SQL distinct
• SQL where
• SQL AND & OR
• SQL Order By
• SQL insert
• SQL update
• SQL delete

Tajriba koyarwa SQL ta tsaki

• SQL Top
• SQL Like
• SQL Wildcard
• SQL In
• SQL Between
• SQL Aliases
• SQL Join
• SQL Inner Join
• SQL Left Join
• SQL Right Join
• SQL Full Join
• SQL Union
• SQL Select Into
• SQL Create DB
• SQL Create Table
• SQL Constraints
• SQL Not Null
• SQL Unique
• SQL Primary Key
• SQL Foreign Key
• SQL Check
• SQL Default
• SQL Create Index
• SQL Drop
• SQL Alter
• SQL Increment
• SQL View
• SQL Date
• SQL Nulls
• SQL isnull()
• SQL Data Types
• SQL 服务器

SQL Functions

• SQL functions
• SQL avg()
• SQL count()
• SQL first()
• SQL last()
• SQL max()
• SQL min()
• SQL sum()
• SQL Group By
• SQL Having
• SQL ucase()
• SQL lcase()
• SQL mid()
• SQL len()
• SQL round()
• SQL now()
• SQL format()

Tajriba SQL

• Rafancin Rari SQL
• Tajriba koyarwa SQL

Fonkili SQL

• Fonkili SQL

Kwararrun

Tabbatar da koyarwa:

• Kabara CodeW3C.com

Opereta UNIYON SQL

Opereta UNIYON wajaba da samar da yadda suke da SELECT ƙanamoyin biyu ko fiye.

Riwayar da a yarda, yadda UNIYON a tsaki da SELECT ƙanamoyin wajaba kuma da yadda suke. Ƙananan da ke a kan yadda suke da ƙananan daban-daban. Kuma, kowane SELECT ƙanamoyin wajaba kuma da yadda suke da ƙananan daban-daban.

Giriyar amannar SQL UNION

SELECT column_name(s) FROM table_name1
UNION
SELECT column_name(s) FROM table_name2

Kanam:Kai a girmi, amannar UNION a kai girmi kowa kowa ce. Idan a girmi kowa kowa ce, a girmi UNION ALL.

Giriyar amannar SQL UNION ALL

SELECT column_name(s) FROM table_name1
UNION ALL
SELECT column_name(s) FROM table_name2

Kuma, sunan kowaci a girmi a na amannar UNION a kai girmi kowa kowa ce a na amannar SELECT amannar farko.

Dokar da a girmi a na amannar:

Employees_China:

Employees_USA:

A girmi amanar UNION

Dokar:

Dokar ko a girmi kowa kowa ce a na China da America:

SELECT E_Name FROM Employees_China
UNION
SELECT E_Name FROM Employees_USA

Dokar

Kanam:Amannar a kai girmi kowa kowa ce a na China da America. A girmi amannar dukkanin sunan na a girmi. Amannar UNION a kai girmi kowa kowa ce.

UNION ALL

Amannar UNION ALL da amannar UNION sunan su ne, amma amannar UNION ALL a girmi kowa kowa ce.

SQL Statement 1
UNION ALL
SQL Statement 2

A girmi amanar UNION ALL

Dokar:

Dokar ko a girmi a na China da America:

SELECT E_Name FROM Employees_China
UNION ALL
SELECT E_Name FROM Employees_USA

Dokar

Kabara

Fonkili SQL

Rafancin sasancin