Comprehension Passage
Case study based question
An Educational Institute in Delhi make use of DBMS to store details of students. The institute maintains a database named 'school - record' under which there are two tables.
1. Student table : maintains general details of every student enrolled in the school
2. Stulibrary Table: To store the details of issued books.
* BookID is the unique identification number of each book.
* Minimum issue duration of a book is one day.
|
Student |
|
|
Field |
Type |
|
StuID |
Numeric |
|
StuName |
Varchar(20) |
|
StuAddress |
Varchar(50) |
|
StuFatherName |
Varchar(20) |
|
StuContact |
Numeric |
|
StuAadhar |
Numeric |
|
StuClass |
Varchar(5) |
|
StuSection |
Varchar(1) |
|
Stulibrary |
|
|
Field |
Type |
|
BookID |
Numeric |
|
StuID |
Numeric |
|
Issued_date |
Date |
|
Return_date |
Date |
Identify the SQL query which displays the data of table Stulibrary in ascending order of student ID.
1
Select * from Stulibrary order by BookID;
2
Select * from Stulibrary order by StuID ascending:
3
Select * from Stulibrary order by StulD Asc;
4
Select * from Stulibrary order by StuID DESC;