COMPUTER PROGRAMMING FUNDAMENTALS
WHAT IS PROGRAMMING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
UPDATE
|
|
|
CREATE TABLE
|
|
|
WHERE
|
|
|
WHICH
|
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: -An SQL SELECT statement retrieves records from a database table according to clauses (for example, FROM and WHERE ) that specify criteria.
Detailed explanation-3: -SELECT statement uses * character to retrieve all records from a table, for all the columns. The above query will show all the records of student table, that means it will show complete dataset of the table.
Detailed explanation-4: -The ORDER BY command is used to sort the result set in ascending or descending order. The ORDER BY command sorts the result set in ascending order by default. To sort the records in descending order, use the DESC keyword.