Question

In a table EMPLOYEE(eid, name, age), write the query for displaying employee details where 5th
character of their name is 'e',​

Answer 1

Answer:

Create Database DB1;

Use DB1;

Create Table EMPLOYEE ( employee ID Primary Key , Name VARCHAR (10) ,Age (Int) ;

Insert Into EMPLOYEE values ( 'B001 ', 'a' , 20 ) ;

Insert Into EMPLOYEE values ( 'B002', 'b' , 22) ;

Insert Into EMPLOYEE values ( 'B003', 'c' , 30 ) ;

Insert Into EMPLOYEE values ( 'B004', 'd' , 28 ) ;

Insert Into EMPLOYEE values ( 'B005' , 'e' , 25 ) ;

SELECT * FROM EMPLOYEE ;

Explanation:

Here is ur correct answer , I'm also a student of class X , computer science ,hope it is helpful to you all the best for upcoming HSLC examination.