Scribd
Upload
5 views6 pages

SQL Queries for Student Database Management

The document contains a series of SQL commands and queries related to a student database. It includes instructions for inserting values, adding a new column for total marks, deleting sections, assigning primary keys, and various queries to display student data based on specific conditions. Additionally, it covers commands for deleting a table and database.

Uploaded by

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

SQL Queries for Student Database Management

The document contains a series of SQL commands and queries related to a student database. It includes instructions for inserting values, adding a new column for total marks, deleting sections, assigning primary keys, and various queries to display student data based on specific conditions. Additionally, it covers commands for deleting a table and database.

Uploaded by

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

Q-3 Insert five values in above table.

Q-4 Write a command to add a new


column total marks and insert the
value PT1+SA1+PT2+SA2.

Q-5 Write a query to delete section ‘A’.


Q-6 Write a command to assign
primary key consequent to studentID.

Q-7 Write a query to display data in


table.
Q-8 Write a query to display studentID ,
class , Sname and total marks of those
having total marks more than 190.

Q-9 Write a query to display name of


those students who have middle name
kumar or last name singh.

Q-10 Write a query to display Sname of


those who secured more marks in PT2
than PT1.
Q-11 Write a query to display studentID
, of those who have totalmarks
between 150 & 180 both included.

Q-12 Write a query to display studentID


, DOB who have null in their DOB.
Q-13 Write a query to display studentID
, half of PT1 & half of PT2 those who
have totalmarks more than 180.

Q-14 Write a query to display studentID


,Sname , average of SA1 & SA2 of those
who have five letters in their names.

Q-15 Write a query to delete table and


database.

You might also like