22.08.2024

0

Like

22

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

Disclaimer: The information /programs / events provided on https://patika.dev and https://risein.com are strictly for upskilling and networking purposes related to the technical infrastructure of blockchain platforms. We do not provide financial or investment advice and do not make any representations regarding the value, profitability, or future price of any blockchain or cryptocurrency. Users are encouraged to conduct their own research and consult with licensed financial professionals before engaging in any investment activities. https://patika.dev and https://risein.com disclaim any responsibility for financial decisions made by users based on information provided here.