QUICK BRUSH UP - SQL

1. Select Query

Select * from TableName;

Select * from TableName
Where Unique Constaint;

Select field1, field2, field3...
FROM TableName

Select * from TableName
Where Unique Constaint;

2. Select Query + DISTINCT

Select DISTINCT column1, column2, ....
FROM TableName;

3. Select + Where + And/ Or/ Not

Select * from TableName
Where field1 = 'value' AND field2= 'value';

Select * from TableName
Where field1 = 'value' OR field1 = 'Value2';

Select * from TableName
Where NOT field1 = 'Value';

4. ORDER BY :-

Select * from TableName
ORDER BY 1;

Select * from TableName
ORDER BY fieldName ASC;

Select * from TableName
ORDER BY fieldName DESC;

Select * from TableName
ORDER BY fieldName ASC, fieldName1  DESC;

5. NULL Value :-

Select * from TableName
Where fieldName IS NULL;

Select * from TableName
Where fieldName IS NOT NULL;

6. UPDATE :-

Update TableName
SET column1 = 'value1', column2 = 'value2'
Where condition;

7. DELETE :-

--Single/ Multiple DELETE
Delete FROM TableName
Where Condition;


--Delete All Rows
Delete FROM TableName;

8. MIN & MAX :-

--MIN
Select MIN(FieldName)
FROM TableName
Where Condition;

--MAX
Select MAX(FieldName)
FROM TableName
Where Condition;

9. COUNT / AVERAGE / SUM :-

--COUNT
Select COUNT(FieldName)
FROM TableName
Where Condition;

--AVERAGE
Select Average(FieldName)
FROM TableName
Where Condition;

--SUM
Select SUM(FieldName)
FROM TableName
Where Condition;

10. SQL LIKE Operator :-

--( % )
Select * FROM TableName
Where fieldName LIKE 'a%';

--( _ )
Select * FROM TableName
Where fieldName LIKE '_a';

-- ( COMBINATION OF % AND _ )
Select * FROM TableName
Where FieldName = 'a_%';

Selcect * FROM TableName
Where FieldName LIKE '_R%';

11. SQL IN Operator :-

--Allows you to specify multiple Values in WHERE condition
Select * FROM TableName
Where FieldName IN('Value1','Value2', 'Value3');

Select * FROM TableName
Where FieldName NOT IN ('Value1', 'Value2', 'Value3');

12. BETWEEN Operator :-

Select * FROM TableName
Where FieldName BETWEEN 'Value1' AND 'Value2';

Select * FROM TableName
Where FieldName NOT BETWEEN 'Value1' AND 'Value2';

13. SQL Aliases :-

-- Provides Temporary Name to your Table, Column
Select ColumnName AS AliasName
FROM TableName;

Select * FROM TableName As AliasName;