Question

Please answer this question as fast as you can.......

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


Field Type
Emp_no. char(4)
Name varchar(25)
Salary Float
Department varchar(15)

Answer 1

CREATE TABLE tablename (Emp_no char(4), Name varchar(25), Salary float, Department varchar(15));