0% found this document useful (0 votes)
1 views1 page

MySQL 1

Uploaded by

sarvildahiya2010
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
0% found this document useful (0 votes)
1 views1 page

MySQL 1

Uploaded by

sarvildahiya2010
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

1 Display all records of students who are in Class 10 and scored more than 80 marks.

2 Show details of students who belong to Delhi and scored 75 or more marks.

3 Display records of students who belong to Mumbai or Pune.

4 Show details of students who scored less than 40 marks or belong to Class 9.

5 Display records of students who do not belong to Delhi.

6 Show details of students whose marks are not less than 50.

7 Display all student records in ascending order of marks.

8 Show all student records in descending order of student names.

9 Display all student records sorted by Class in ascending order and Marks in descending order.

10 Delete the record of the student whose Roll Number is 101.

11 Delete all student records where marks are less than 30.

12 Display records of students whose City value is NULL.

13 Show records of students whose City value is not NULL.

14 Display records of students whose names start with the letter ‘A’.

15 Show details of students whose names end with the letter ‘n’.

16 Display records of students whose second letter in the name is ‘a’.

17 Update the marks of the student having Roll Number 105 to 90.

18 Update the City to Chandigarh and Marks to 85 for the student named Rahul.

19 Increase marks by 5 for students of Class 10 who scored less than 60 marks.

20 Delete records of students who belong to Delhi or Mumbai.

You might also like