22.08.2024

0

Like

17

Views

SQL Ödev 11

  • actor ve customer tablolarında bulunan first_name sütunları için tüm verileri sıralayalım.
SELECT first_name FROM actor UNION SELECT first_name FROM customer ORDER BY first_name;
  • actor ve customer tablolarında bulunan first_name sütunları için kesişen verileri sıralayalım.
SELECT first_name FROM actor INTERSECT SELECT first_name FROM customer ORDER BY first_name;
  • actor ve customer tablolarında bulunan first_name sütunları için ilk tabloda bulunan ancak ikinci tabloda bulunmayan verileri sıralayalım.
SELECT first_name FROM actor EXCEPT SELECT first_name FROM customer ORDER BY first_name;
  • İlk 3 sorguyu tekrar eden veriler için de yapalım.
SELECT first_name FROM actor UNION ALL SELECT first_name FROM customer ORDER BY first_name;
SELECT first_name FROM actor INTERSECT ALL SELECT first_name FROM customer ORDER BY first_name;
SELECT first_name FROM actor EXCEPT ALL SELECT first_name FROM customer ORDER BY first_name;
SQL

Comments

You need to log in to be able to comment!

Kenan Ayberk Özkan

I’m looking for places where I can use my interest in software or design, improve my existing skills and myself, especially add new talents to shape my business life.

Location

Elazığ, TR

Education

Elektrik - Elektronik Mühendisliği - Fırat Üniversitesi

Job Experience

INTERN - EÜAŞ KEBAN DAM

INTERN R&D - MOSAŞ GROUP

INTERN EMBEDDED SYSTEMS - PAVOTEK

© 2021 Patika Dev

facebook
twitter
instagram
youtube
linkedin