Scribd
Upload
218 views1 page

SQL Queries for School Database Analysis

The document provides 15 SQL queries to retrieve student data from a school database table with fields for roll, name, class, section, address, city, and phone. The queries select specific fields and filter records based on values in the class, section, city, and other fields. For example, some queries retrieve students who live in a particular city, study in a certain class or section, or have names starting with a given letter.

Uploaded by

Ghanshyam Sharma
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
218 views1 page

SQL Queries for School Database Analysis

The document provides 15 SQL queries to retrieve student data from a school database table with fields for roll, name, class, section, address, city, and phone. The queries select specific fields and filter records based on values in the class, section, city, and other fields. For example, some queries retrieve students who live in a particular city, study in a certain class or section, or have names starting with a given letter.

Uploaded by

Ghanshyam Sharma
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
You are on page 1/ 1

INFOTECH where quality matters

MYSQL ASSIGNMENT - 1
Question. Suppose there is a table named SCHOOL? Write SQL Queries as per the following table fields -
ROLL, NAME, CLASS, SECTION, ADDRESS, CITY, PHONE
Q1. Display roll and name of all the students ?

Q2. Display roll and name of those who lives in Kishangarh ?

Q3. Display roll number of those students who study in class XI ?

Q4. Display all the details of student whose class is XI or XII ?

Q5. Display all the details of students who study in XIIth C. ?

Q6. Display name of those students who do not have phone number ?

Q7. Display all the details of students whose name starts with letter A ?

Q8. Display roll and class of those students who lives in ajmer and reads in XIth C?

Q9. Display details of those students who lives in Ajmer Jaipur or Beawar ?

Q10. Display all the details of student who do not lives in Ajmer ?

Q11. Display details of students whose name starts with C and lives at Beawar ?

Q12. Display details of those students who reads in sec a and sec b but not in xith ?

Q13. Display name of students who do not study in XIIth C ?

Q14. Display details of students who are in XIIth class but not lives in Ajmer ?

Q15. Display names of those students who are not studying in C Section ?

FIRST FLOOR, OPPOSITE BANK OF BARODA


AJMER RO AD, KISHANGARH (RAJ) 305801 CALL:+91-98291-71122
EMAIL:in [email protected] | WEBSITE:ww w.infotechcomputer .in

You might also like