SQL Interview Questions | First name
Question
NAME | SALARY | Date of Joining |
Angad | 50,000 | 05 July |
Bhuvan | 52,000 | 19 March |
Danish | 77,000 | 06 September |
Manhar | 64,000 | 15 May |
Shivraj | 50,000 | 10 July |
Tanuj | 55,000 | 13 August |
Get all the employee detail from Employee Detail table whose “FirstName” starts with A and contain 5 letters.
in progress
0
SQL
4 years
4 Answers
1486 views
Great Grand Master 0
Answers ( 4 )
select * from employee_details where first_name like ‘A%’ and length(first_name)=5;
select * from employee where first_name like ‘A%’ and length(first_name)=5
Select*from EmployeeDetailTable
where Name like ‘A%’ and length(Name)=5;
SELECT *
FROM EMPLOYEE
WHERE NAME LIKE ‘A____’
OR
SELECT *
FROM EMPLOYEE
WHERE NAME LIKE ‘A%’ and length(NAME)=5