MYSQL
SOLUTION
Write SQL statements for the following based on table Garments:
Create above table in MySQL.
Insert records.
To display the detail of class XII students in descending order of their marks.
Display all the details of students in ascending order of name.
Find the maximum marks of the student for each class.
Count the students class wise is display only those number who is more than 2.
Display unique cities from the table.
CREATE DATABASE .
ACCESS DATABSE.
Sol 1 :- Create TABLE STUDENT.
Sol 2 :- INSERT INTO STUDENT TABLE.
Sol 3 :- To display the detail of class XII students in descending order of their marks.
Sol 4 :- Display all the details of students in ascending order of name.
Sol 5 :- Find the maximum marks of the student for each class.
Sol 6 :- Count the students class wise is display only those number who is more than 2.
Sol 7:- Display unique cities from the table.
