Scribd
Upload
26 views

My SQL

SQL PROGRAMMING

Uploaded by

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

My SQL

SQL PROGRAMMING

Uploaded by

sachinjangra98
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 18

Query 5

Use the command to get the details of the students with marks more than
15.

Output:
Query 6
Find the minimum, maximum and average of marks in students table.
Query 7
Write a command to display details of a student whose name start with g

Output:
Query 8
Write a command to display rollno., name, DOB of those students who
are born between 2021-01-01 and 2021-12-31.

Output:
Query 9
Write a command to display rollno,name,dob,marks of male students in
ascending order of their name.

Output:
Query 10
Write a command to display the unit section available in the table.

Output:
Query 11
Write an SQL query to sort the studentid,marks in descending order of
their marks.

Output:
Query 12
Write a command to add a new column named email in the above table
student.

Output:
Query 13
Write a command to increase marks by 5% of those students who have
rollno more than 5.

Output:

`
Query 14
Write a command to delete the table students from the database.

Output:
Query 15
Find the total number of customer from each country in the customer
table (customerid,name,country).

Output:
Query 3
Display the details of table students

Output:
Query 4
Delete the details of the students in the above table.

Output:
Query 2

Insert the details of 10 students


Query 1

Create a table student with student_ID , name , marks , Rollno , class ,


section , DOB , gender as attributes where the student_ID is primary
key.(Take student_ID as sid)

Output:
INDIAN MODERN SR SEC SCHOOL

PRACTICAL RECORD FILE IS SUBMITTED TO DEPARTMENT OF


INFORMATICS PRACTICES FOR THE PARTIAL FULLFILLMENT OF
AISSCE EXAMINATION SESSION 2024-25

SUBMITTED TO: SUBMITTED BY:

Ms. PREETI NAME:

ROLLNO:
SQL COMMANDS
S.NO. PRACTICAL SIGNATURE
1 Create a table student with studentid , name ,marks,
rollno, class, section, DOB, gender as attributes
where studentid is PRIMARY KEY(take studentid
as stuid).
2 Insert the details of 10 students.

3 Display the details of table student.

4 Delete the details of student in above table.

5 Use the command to get the details of the students


with marks more than 15.
6 Find the minimum, maximum and average of
marks in the student table.
7 Write a command to display details of student
whose name starts with g.
8 Write a command to display roll no., name, DOB,
of those students who are born between 2021-01-01
and 2021-12-31.
9 Write a command to display roll no., name, DOB,
marks of male students in ascending order of their
name.
10 Write a command to display the unit section
available in the table
11 Write an SQL query to sort the studentid, marks in
descending order of their marks,
12 Write a command to add a new column named
email in the above table student.
13 Write a command to increase marks by 5% of those
students who have roll no, more than 5.
14 Write a command to delete the table student from
the database.
15 Find the total no. of customer from each country in
the customer table(customerid, name, country).

You might also like