Consider the following employee table. Write SQL commands for the question. EMP CODE NAME DESIG PAY ALLO WANCE S1001 Hariharan Supervisor 29000 12000 P1002 Shaji Operator 10000 5500 P1003 Prasad Operator 12000 6500 C1004 Manjima Clerk 8000 4500 M1005 Ratheesh Mechanic 20000 7000 To add a new row.

Consider the following employee table. Write SQL commands for the question. To add a new row. - Computer Science

Consider the following employee table. Write SQL commands for the question.

To add a new row.

One Line Answer

INSERT INTO Employee VALUES(/C1006,/ ‘Ram’, ‘Clerk’,15000, 6500);

shaalaa.com

SQL Commands and Their Functions

Is there an error in this question or solution?

Chapter 12: Structured Query Language (SQL) - Evaluation [Page 231]

Chapter 12 Structured Query Language (SQL)
Evaluation | Q 2. (iv) | Page 231

The command to delete a table is ______

The clause used to sort data in a database.

Write a query that selects all students whose age is less than 18 in order wise.

Which component of SQL lets inserts values in tables and which lets to create a table?

What is a constraint?

Write the use of the Savepoint command with an example.

Consider the following employee table. Write SQL commands for the question.

To display the details of all employees in descending order of pay.

What are the components of SQL? Write the commands in each.

Construct the following SQL statement in the student table-

SELECT statement using ORDER BY clause.

Write a SQL statement to create a table for employees having any five fields and create a table constraint for the employee table.