Question

Write the queries based on the following table STUD .

(a) Write SQL command to create the above table
STUD.
(b) Write query to display the whole table.
(c) Write query to display the detail of Ramlal.
(d) Write query to display the detail of those whose
grade is A..
(e) Write query. to display the table in ascending
order of their marks.
(f) Write query to print the name of those whose
marks and more than 75.
(g) Write query to print those names which starts
with letter 'S'.
(h) Write query to insert the following row:
105, "Mahesh", 85, B
(i) Write query to delete the record of "Ramlal"
from table.

Answer 1

Answer:

SQL add column is used to add column operation into the existing SQL table.

...

If we want to add multiple columns to the existing table using any single statement, we can use the below syntax:

ALTER TABLE table_name (Name of the table)

ADD [COLUMN] column_definition, (for adding column)

ADD [COLUMN] column_definition,

Explanation:

please mark me as brilliant