Question

Write a query to display student ID, First name and age. Sort the result based on student ID.

Answer 1

Query:

SELECT

         student_ID, First_name, age

FROM

         Student

ORDER BY

         student_ID ASC;

Explanation:

To extract and print certain columns' data from a table, we use the SELECT command.

To sort down the tuples by some column's data, we use the ORDER BY clause followed by that column name.

To sort down, we have two choices. ASC (ascending) and DESC (descending).

So, the total query will be:

SELECT

           <column1name>, <column2name>, ...

FROM

           <Table_name>

ORDER BY

           <Column_name> ASC | DESC;

Learn more:

1. What are the maximum and the minimum number of rows returned by the R1 right outer join R2?

brainly.in/question/21195376

2. Write SQL commands for (a) to (e) on the basis of FAMILY relation given below:

brainly.in/question/15115256