SELECT Query SELECT FROM SELECT DISTINCTALL columnexpression table
(SELECT Query) ﺍﺳﺘﻌﻼﻡ ﺍﻻﺧﺘﻴﺎﺭ SELECT –FROM ﺍﻟﺼﻴﻐﺔ ﺍﻟﻌﺎﻣﺔ ﻟﺠﻤﻠﺔ � SELECT [DISTINCT|ALL] { * | column_expression | [table. ] column 1[As alias] [, [ table. ] column 2[As aliase ] [, . . ]]} FROM table_name [, … ] [WHERE condition] [GROUP BY column_list] [HAVING condition] [ORDER BY column_list [ASC|DESC]];
ﺍﻻﺳﺘﻌﻼﻡ ﻋﻠﻰ ﻛﻞ ﺍﻟﺒﻴﺎﻧﺎﺕ Sno fname lname position sex DOB salary bno SL 21 John White Manager M 1 -Oct-45 SG 37 Ann Beech Assistant F 10 -Nov-60 12000 B 003 SG 14 David Ford Supervisor M 24 -Mar-58 18000 B 003 SA 9 Mary Howe Assistant F 19 -Feb-70 9000 SG 5 Susan Brand Manager F 13 -Jun-40 24000 B 003 30000 B 005 B 007 **��� �������� ��� ������� ��� �� ����� ���
ﺍﺳﺘﺮﺟﺎﻉ ﺑﻌﺾ ﺍﻟﻤﻌﻠﻮﻣﺎﺕ ﻋﻠﻰ ﺍﻟﺒﻴﺎﻧﺎﺕ STUDENT Student. No Fname Lname GPA 4170010 Amal Al-Saleh 3. 91 4182000 Nora Al-Ghanem 4. 20 4182034 Laila Al-Fahad 4188134 Amal Saod 3. 01 4189860 Rana Rashed 2. 31 4. 01
Alias ﺍﺳﺘﺨﺪﺍﻡ STUDENT number First_name Lname 4170010 Amal Al-Saleh 4182000 Nora Al-Ghanem 4182034 Laila Al-Fahad 4188134 Amal Saod 4189860 Rana Rashed ﻣﻼﺣﻈﺔ** ﻫﺬﺍ ﻻ ﻳﺆﺜﺮ ﻋﻠﻰ ﺃﺴﻤﺎﺀ ﺍﻟﺤﻘﻮﻝ ﻓﻲ ﺍﻟﺠﺪﺍﻭﻝ ﺍﻻﺻﻠﻴﺔ �
( ﻓﻲ ﻋﻤﻠﻴﺔ ﺍﻻﺳﺘﺮﺟﺎﻉ DISTINCT) ﺍﺳﺘﺨﺪﺍﻡ position Manager Assistant Supervisor Assistant Manager SELECT position FROM staff; SELECT DISTINCT position FROM staff;
( ﻓﻲ ﻋﻤﻠﻴﺔ ﺍﻻﺳﺘﺮﺟﺎﻉ DISTINCT) ﺍﺳﺘﺨﺪﺍﻡ First. Name last. Name DOB email city John Smith 12/12/1969 john. smith@john-here. com New York David Stonewall 01/03/1954 david@sql-tutorial. com San Francisco Susan Grant 03/03/1970 susan. grant@sql-tutorial. com Los Angeles Paul O'Neil 09/17/1982 paul. oneil@pauls-email. com New York Stephen Grant 03/03/1974 sgrant@sgrantemail. com Los Angeles � User (id , first. Name, last. Name, DOB, email, city) : ﻣﺜﺎﻝ v . ﺍﻟﻤﻄﻠﻮﺏ ﺍﺳﺘﺮﺟﺎﻉ ﺍﻟﻤﺪﻥ ﺍﻟﺘﻲ ﻳﺴﻜﻨﻬﺎ ﺍﻟﻤﺴﺘﺨﺪﻣﻴﻦ 1 - SELECT DISTINCT city FROM User ; : ﺍﻟﺤﻞ v city New York San Francisco Los Angeles
ﻋﻤﻞ ﻋﻤﻠﻴﺎﺕ ﺣﺴﺎﺑﻴﺔ ﻓﻲ ﺟﻤﻞ ﺍﻻﺳﺘﻌﻼﻡ sal Sno sno � 30010 SL 21 12010 SG 37 18010 SG 14 9010 SA 9 24010 SG 5
- Slides: 19