please guys answer this fast.. it's very much important.. please...
1. write SQL command to create the above given table and. Set appropriate datatype for the fields.
2. Write a query to display the details of all the student in class 10.
3. Write the query to change the Roll_No of the student name Aman to 106.
4. Write a query to delete the record where the value of marks is 1.
5. Write a query to delete the entire table from database.
6. Write a query to display the name and class of those students whose name begins with A.
7. Write a query to display the name, roll no, marks, of all the student in ascending order of marks.
please guys please answer it fast... I know there r many questions but please answer fast.. it's very urgent.. please please please..
Share
Answer:
please guys answer this fast.. it's very much important.. please...
1. write SQL command to create the above given table and. Set appropriate datatype for the fields.
2. Write a query to display the details of all the student in class 10.
3. Write the query to change the Roll_No of the student name Aman to 106.
4. Write a query to delete the record where the value of marks is 1.
5. Write a query to delete the entire table from database.
6. Write a query to display the name and class of those students whose name begins with A.
7. Write a query to display the name, roll no, marks, of all the student in ascending order of marks.
please guys please answer it fast... I know there r many questions but please answer fast.. it's very urgent.. please please please..