Name job Sal Sead Seller 3000 Omer leader

Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 3500 T. Bedor SQL>select name , job , sal From emp where sal <=3000 4

Name job Sal Reem leader 2000 Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor SQL>select name , job , sal From emp where name = ‘Reem’ 5

SQL>select name , sal From emp where sal Between 1000 And 3000 Name Sal Sead 3000 Reem 2000 Name Sal Sead 3000 Omer 5000 Reem 2000 T. Bedor ﺣﺼﺮ ﺍﻟﺒﻴﺎﻧﺎﺕ ﺑﻴﻦ ﺭﻗﻤﻴﻦ 7

SQL>select name , id From emp where id IN (101, 103 ) Name Id Sead 101 sara 103 Name Id Sead 101 omer 102 sara 103 T. Bedor ﺣﺼﺮ ﺍﻟﺒﻴﺎﻧﺎﺕ ﺿﻤﻦ ﻣﺠﻤﻮﻋﻪ ﻣﻦ ﺍﻟﻘﻴﻢ 8

SQL>select name , job , sal From emp where name LIKE ‘o%’ Name job Sal Omer leader 5000 Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor o ﻋﺮﺽ ﺍﻟﻤﻮﻇﻔﻴﻦ ﺍﻟﺬﻱ ﺗﺒﺪﺍﺀ ﺍﺳﻤﺎﺋﻬﻢ ﺑﺎﻟﺤﺮﻑ 9

SQL>select name , job , sal From emp where job LIKE ‘%r ’ Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor r ﻋﺮﺽ ﻋﻤﻞ ﺍﻟﻤﻮﻇﻔﻴﻦ ﺍﻟﺬﻱ ﺗﻨﺘﻬﻲ ﺑﺎﻟﺤﺮﻑ 10

SQL>select name , job From emp where name LIKE ‘_e%’ Name job Sead Seller Reem leader Name job Sead Seller Omer leader Reem leader T. Bedor ﻋﺮﺽ ﻋﻤﻞ ﺍﻟﻤﻮﻇﻔﻴﻦ ﺍﻟﺬﻱ ﻳﻜﻮﻥ ﺍﻟﺤﺮﻑ ﺍﻟﺜﺎﻧﻲ e ﻣﻦ ﺍﺳﻤﺎﺋﻬﻢ ﻫﻮ 11

SQL>select name , job From emp where name LIKE ‘_ _e%’ Name job Omer leader Reem leader Name job Sead Seller Omer leader Reem leader T. Bedor ﻋﺮﺽ ﻋﻤﻞ ﺍﻟﻤﻮﻇﻔﻴﻦ ﺍﻟﺬﻱ ﻳﻜﻮﻥ ﺍﻟﺤﺮﻑ ﺍﻟﺜﺎﻟﺚ e ﻣﻦ ﺍﺳﻤﺎﺋﻬﻢ ﻫﻮ 12

ﻋﺮﺽ ﺍﺳﻢ ﺍﻟﻤﻮﻇﻒ ﻭ ﻋﻤﻠﻪ ﺍﻟﺬﻳﻦ ﻟﻬﻢ ﻋﻤﻞ SQL>select name , job From emp where job Is Null Name job Sead Seller Omer leader Reem Leader Sarh T. Bedor ﻻ ﻳﻮﺟﺪ job Sarh 13

AND ﺍﻟﻤﻌﺎﻣﻞ job sal Sead Seller 3000 Omer leader 5000 Reem Leader 2000 Sarh Name job sal Sead Seller 3000 SQL>select name , job , sal From emp where sal>=3000 and job IS NULL Name job sal Sead Seller 3000 Omer leader 5000 Reem Leader 2000 Sarh ( ﻟﻢ ﻳﺘﺤﻘﻖ ﺍﻟﺸﺮﻃﻴﻦ )ﻻ ﺗﻮﺟﺪ ﻧﺘﻴﺠﻪ 2000 T. Bedor SQL>select name , job , sal From emp where sal>=3000 and job = seller Name 2000 15

OR ﺍﻟﻤﻌﺎﻣﻞ Name job sal Sead Seller 3000 Omer Leader 5000 SQL>select name , job , sal From emp where sal>=3000 OR job = Leader Name job sal Sead Seller 3000 Omer Leader 5000 Reem Leader 2000 Sarh 2000 Name job sal Sead Seller 3000 Omer leader 5000 Reem Leader 2000 Sarh T. Bedor SQL>select name , job , sal From emp where sal>=3000 OR job = seller 2000 16

NOT ﺍﻟﻤﻌﺎﻣﻞ Name SQL>select name , job , sal Sead From emp where name Not IN (‘omer’, ’Reem’) Omer Reem job sal Sead Seller 3000 Sarh sal Seller 3000 Leader 5000 Leader 2000 Sarh 2000 T. Bedor Name job 2000 SQL>select name , job , sal From emp where sal Not Between 1000 And 3000 Name job sal Omer Leader 5000 Name job sal Sead Seller 3000 Omer Leader 5000 Reem Leader 2000 Sarh 2000 17

NOT ﺍﻟﻤﻌﺎﻣﻞ Name job sal Omer Leader 5000 Reem Leader 2000 SQL>select name , job , sal From emp where sal Not NULL Name job sal Sead Seller 3000 Omer Leader 5000 Reem Leader 2000 Sarh 2000 T. Bedor SQL>select name , job , sal From emp where name Not LIKE ‘S%’ Name job sal Sead Seller 3000 Omer Leader 5000 Leader 2000 Name job sal Reem Sead Seller 3000 Sarh Omer Leader 5000 Reem Leader 2000 18

SQL>select name , job , sal From emp where job = ‘leader’ Order By Sal ASC Name job Sal Reem leader 2000 Omer leader 5000 Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor ﻋﺮﺽ ﺍﺳﻤﺎﺀ ﺍﻟﻤﻮﻇﻔﻴﻦ ﻭﺍﻟﻌﻤﻞ ﻭﺭﺍﺗﺐ ﺍﻟﺬﻳﻦ ﺗﺼﺎﻋﺪﻳ ( ﻣﻊ ﺗﺮﺗﻴﺐ leader) ﻳﻌﻤﻠﻮﻥ 20

SQL>select name , job , sal From emp where job = ‘leader’ Order By Sal DESC Name job Sal Omer leader 5000 Reem leader 2000 Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor ﻋﺮﺽ ﺍﺳﻤﺎﺀ ﺍﻟﻤﻮﻇﻔﻴﻦ ﻭﺍﻟﻌﻤﻞ ﻭﺭﺍﺗﺐ ﺍﻟﺬﻳﻦ ﺗﻨﺎﺯﻟﻴ ( ﻣﻊ ﺗﺮﺗﻴﺐ leader) ﻳﻌﻤﻠﻮﻥ 21

SQL>select * From emp Order By Sal DESC Name job Sal Omer leader 5000 Reem leader 2000 Name job Sal Sead Seller 3000 Omer leader 5000 Reem leader 2000 T. Bedor ﻋﺮﺽ ﺟﻤﻴﻊ ﺑﻴﺎﻧﺎﺕ ﺍﻟﻤﻮﻇﻔﻴﻦ ﻣﻊ ﺗﺮﺗﻴﺐ sal ﺗﻨﺎﺯﻟﻴ ﻟﻌﻤﻮﺩ ﺍﻟﺮﺍﺗﺐ 22