Select is the fundamental statement of structured query language which is used for to retrieve the data information from the main database. The Select statement is follow the right format to execute the query and begins with the Select keyword followed by the columns to be included in the format. when we are used an asterisk like * is placed after Select then that time there must be used FROM clause. These data sources may be a single table, combination of tables, sub query or view. Optional clauses may be added but are not mandatory the WHERE clause that gives conditions for returning data, or the ORDER BY clause that sorts output with one or more of the specified columns.