Tuesday, 3 September 2013

SQL SELECT DISTINCT Statement

DISTINCT keyword can be used to return only distinct (Unique) values.

SQL SELECT DISTINCT Syntax


SELECT DISTINCT column_name,column_name

FROM table_name;


SQL SELECT Statement

SELECT statement is used to select particular data from database.

SQL SELECT Syntax


SELECT column_name,column_name
FROM table_name;
OR


SELECT * FROM table_name;

Entity Framework approaches

There are 3 approaches we can use in Entity Framework

 1.Database First

2. Model First

3. Code First