Question

Write SQL statement for following:
(i). To create a table “StudentsInfo” having Columns AdmissionNo., Name, Class, Section, Address,
City & Mobile. (2)
(ii) To insert a new record in abovesaid table “StudentsInfo” (1)
(iii) To display the "AdmissionNo." and "Name" columns of all students from the abovesaid
StudentsInfo table (1)
(iv) To display all the students from the City "Hansi", in the abovesaid "StudentsInfo" table (

Answer 1

Answer:

FOLLOW LIKE RATE COMMUNICATION

Explanation:

Write SQL statement for following:

(i). To create a table “StudentsInfo” having Columns AdmissionNo., Name, Class, Section, Address,

City & Mobile. (2)

(ii) To insert a new record in abovesaid table “StudentsInfo” (1)

(iii) To display the "AdmissionNo." and "Name" columns of all students from the abovesaid

StudentsInfo table (1)

(iv) To display all the students from the City "Hansi", in the abovesaid "StudentsInfo" table (