COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
report
|
|
|
form
|
|
|
file
|
|
|
table
|
Detailed explanation-1: -The SELECT statement is used to select data from a database. The data returned is stored in a result table, called the result-set.
Detailed explanation-2: -The SQL Select statement is a statement that you use to select data from a database. The result of the SELECT statement is stored in a result table, also known as a result-set.
Detailed explanation-3: -SELECT is the most common operation in SQL, called “the query". SELECT retrieves data from one or more tables, or expressions.
Detailed explanation-4: -When a SELECT statement returns a result set with duplicate rows, you may want to remove them such that each row’s data is unique for a column or combination of fields. To avoid duplicate records, use the DISTINCT or DISTINCTROW identifiers.
Detailed explanation-5: -SELECT statements An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria. The syntax is: SELECT column1, column2 FROM table1, table2 WHERE column2=’value’;