COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
file
|
|
|
report
|
|
|
table
|
|
|
form
|
Detailed explanation-1: -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-2: -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-3: -The result of a SELECT statement is called a result table or result set. What can a result set include? A result set can include calculated values that are calculated from columns in the table.
Detailed explanation-4: -SELECT is the most common operation in SQL, called “the query". SELECT retrieves data from one or more tables, or expressions.
Detailed explanation-5: -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.