Question

Write SQL queries for following statements:
a) To create a database of your name.
b) To create a table name student having columns sno, rno, sname, class, city.
c) To display all records of student table.
d) To display students details of class 5.
e) To insert a record in student table (1, 1605, ‘Atul’, 10, ‘Shimla’)
f) To display rno, sname, city of student table
g) To display unique city records of student table
h) To display the information all the students, whose name starts with ‘AN’ (Examples: ANAND, ANGAD,..)
i) To display rno, sname, class of the students in ascending order of their names.
j) To display the structure of student table.​

Answer 1

Below is the answer to the question