Interesting to Queries

{ December 10, 2009 @ 3:55 pm } · { Uncategorized }

Avoid Duplicate Records

SELECT DISTINCT SALARY

FROM EMPLOYEE

Union of two Records-Duplicates are removed

SELECT Date FROM Store_Information

UNION

Union All -Here Duplicates are not removed

Pattern Matching-comparison on condition

%- zero or more characters

_underscore -Single character

SQL IN –

SELECT “column_name”
FROM “table_name”
WHERE “column_name” IN (‘value1′, ‘value2′, …)

An SQL JOIN clause combines records from two or more tables in a database.

Advertisement