Scribd
Upload
7 views1 page

SQL Queries for Student Records

The document describes creating a table called SDetails with columns for student details like name, roll number, class, favorite color, birthdate, and address. It then lists 10 SQL queries to retrieve student records from the table by filtering on columns like favorite color, class, location, and birthdate or sorting by roll number, name, or birthdate.

Uploaded by

Sreyan Bhattacharya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
7 views1 page

SQL Queries for Student Records

The document describes creating a table called SDetails with columns for student details like name, roll number, class, favorite color, birthdate, and address. It then lists 10 SQL queries to retrieve student records from the table by filtering on columns like favorite color, class, location, and birthdate or sorting by roll number, name, or birthdate.

Uploaded by

Sreyan Bhattacharya
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

SQL

 Create the TABLE: SDetails with following schema

 Enter Minimum five records

Following are the SQL query to be executed

Query 1: Display all records from the table

Query 2: Display the list of students whose favorite color is blue

Query 3: Display the list of students of class

Query 4: Display the list of students from Alipore

Query 5: Display the list of students who born after 31 st March 2004

Query 6: Display records in ascending order of RollNo

Query 7: Display records in alphabetical order of the Name

Query 8: Display all records of students in descending order of birthdate

Query 9: Display the list of students whose favourite color is either red or blue

Query 10: Display the list of all class 9 students who stays in Howrah

You might also like