A Select Statement is used for retrieves zero or more rows from database tables or database views which are related to particular table. In database application mostly Select Statement is commonly used for data manipulation language command. In SQL programming language the Select Statement queries specify a result set but do not specify how to calculate it. The database translates the query into a which may vary between executions, database versions and database software. Select Statement is always as Clause which is powerful to retrieve the selected information.