Question

Write a query to create a table with the following structure.
Table
Employee
Field
Datatype
Empld
Char (4)
Empname
Varchar (15)
Designation
Varchar (10)
Salary
Decimal
Write the queries to accomplish the following:
Insert / add a new row with the following data :
('E005', 'Akshit', 'Manager' , 50000.00)
Write the query to display all the records.
Write a query to display Empid and salary of all the employees.​

Answer 1

Answer:

Write a query to create a table with the following structure.

Table

Employee

Field

Datatype

Empld

Char (4)

Empname

Varchar (15)

Designation

Varchar (10)

Salary

Decimal

Write the queries to accomplish the following:

Insert / add a new row with the following data :

('E005', 'Akshit', 'Manager' , 50000.00)

Write the query to display all the records.

Write a query to display Empid and salary of all the employees.