MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Match the following SQL term with a description-FROM
A
The criteria which must be met
B
The fields to display
C
The field and order used to sort the results
D
The table used in the query
Explanation: 

Detailed explanation-1: -The DESC command is used to sort the data returned in descending order.

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: -In SQL, to retrieve data stored in our tables, we use the SELECT statement.

There is 1 question to complete.