SQL Sorgu Dili

SQL (Structured Query Language): Yapılandırılmış Sorgu Dili

SELECT * FROM table;

SELECT column1, column2 FROM table WHERE condition;

SELECT TOP number column FROM table WHERE condition;

SELECT COUNT(column) FROM table WHERE condition;

SELECT SUM(column) FROM table WHERE condition;

SELECT column1, column2 FROM table WHERE condition1 AND condition2 AND condition3;

SELECT column1, column2 FROM table WHERE condition1 OR condition2 OR condition3;

SELECT column1 AS [Adı Soyadı] FROM table WHERE condition;

SELECT LastName + ' ' + FirstName FROM Employees;

SELECT column1, column2 FROM table ORDER BY column1 ASC;

SELECT column1, column2 FROM table WHERE NOT condition;

SELECT column FROM table WHERE column IS NULL;

SELECT column FROM table WHERE column IS NOT NULL;

SELECT MIN(column) FROM table WHERE condition;

SELECT MIN(column) FROM table WHERE condition;

SELECT AVG(column) FROM table WHERE condition;

SELECT column1, column2 FROM table WHERE columnN LIKE pattern; ('A%', '%A%', 'A_k%');

SELECT column FROM table WHERE column BETWEEN value1 AND value2;

SELECT column FROM table WHERE column IN (value1, value2, ...);