Database Management 08.05.2018 (Tuesday) Lab

By | 10.05.2018
Örnek 1

Step 1. Download file from ”Dropbox”

https://www.dropbox.com/s/m0tkg42lzsocd3d/altsorguVeritaban%C4%B1.sql?dl=0

Step 2. Open ”SQL Management Studio”

Step 3. Create Database as name “satis”

Step 4. Open –> File–>Choose downloading file from computer

Step 5. Execute 

Soru: 10 TL üzerindeki ürünlerden alış yapan müşterileri listeleyiniz?

or

Step 6. Execute 

SELECT INTO

SİNTAKSİ

Örnek 1 (using UNION & UNION ALL)

Step 1. Execute

or

Step 2. Execute

Step 3. Execute

Leave a Reply

Your email address will not be published. Required fields are marked *