Postgresql üzerinde çalışıyorsanız, Postgresql ile Tsql Kullanım örnekler tam da size göre. Öncesinde parduz üzerinde Postgresql kurmak için buraya, pgadmin kurmak için ise buraya tıklamanız yeterli.
SELECT QUERY
| 1 | SELECT * FROM CATEGORY |
UPDATE QUERY
| 1 | Update actor set first_name=‘İnanç’, last_name=‘Delibalta’ where actor_id=1 |
INSERT DATA QUERY
| 1 | İnsert into actor (first_name,last_name) values (‘Alper’,‘Delibalta’) |
DELETE DATA QUERY
| 1 | DELETE FROM ACTOR WHERE ACTOR_ID = ‘201’ |
KARŞILAŞTIRMA OPERATÖRLERİ
| Operator | Description | |
| < | less than | Daha Az |
| > | greater than | Daha Büyük |
| <= | less than or equal to | Küçük veya Eşittir |
| >= | greater than or equal to | Büyük veya Eşittir |
| = | equal | Eşit |
| <> or != | not equal | Eşit Değil |
Kaynak < https://www.postgresql.org/docs/12/functions-comparison.html>
| 1 | select * from actor where extract(year from last_update) < ‘2014’ |
| 1 2 | select * from film where replacement_cost >=’20’ order by replacement_cost desc |
JOIN KULLANIMI
| 1 2 3 4 5 6 7 8 9 10 | SELECT CATEGORY.NAME, TITLE, RELEASE_YEAR, FILM.LANGUAGE_ID ,LANGUAGE.NAME FROM CATEGORY INNER JOIN FILM_CATEGORY ON CATEGORY.CATEGORY_ID = FILM_CATEGORY.CATEGORY_ID INNER JOIN FILM ON FILM_CATEGORY.FILM_ID = FILM.FILM_ID INNER JOIN LANGUAGE ON FILM.LANGUAGE_ID = LANGUAGE.LANGUAGE_ID WHERE CATEGORY.CATEGORY_ID = 2 |
CASE WHEN KULLANIMI
| 1 2 3 4 5 6 7 8 9 10 11 12 13 | SELECT TITLE, CASE WHEN REPLACEMENT_COST BETWEEN ‘5’ AND ‘10.99’ THEN ‘Ucuz’ WHEN REPLACEMENT_COST BETWEEN ’11’ AND ‘15.99’ THEN ‘Pahalı Gibi’ WHEN REPLACEMENT_COST BETWEEN ’16’ AND ‘20.99’ THEN ‘Pahalı’ WHEN REPLACEMENT_COST BETWEEN ’21’ AND ‘30.99’ THEN ‘Çok Pahalı’ ELSE ‘ULASILAMAZ’ END AS FIYATARALIKLARI ,REPLACEMENT_COST FROM FILM GROUP BY TITLE, REPLACEMENT_COST ORDER BY REPLACEMENT_COST |
Mükerrer Kayıtları Bulmak İçin Kullanılabilecek Örnek Bir Sorgu
| 1 2 3 4 | select film_id, count (title) from film group by film_id having count (film_id) > 1 order by film_id |
Alt Sorguların Kullanıldığı örnek
| 1 2 3 4 5 6 7 8 9 | SELECT CUSTOMER_ID, (SELECT EMAIL FROM CUSTOMER WHERE PAYMENT.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID) AS EMAIL, (select concat (first_name,last_name) from staff where payment.staff_id = staff.staff_id) as Staffinfo ,SUM (AMOUNT) FROM PAYMENT GROUP BY ORDER BY staffinfo |
