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
Dhruv2301 55 years 4 Answers 1520 views Great Grand Master 0

Answers ( 4 )

  1. Yash Bagaria
    0
    Reply

    select * from employee_details where first_name like ‘A%’ and length(first_name)=5;

  2. Priyabrata017
    1
    Reply

    select * from employee where first_name like ‘A%’ and length(first_name)=5

  3. Sai
    0
    Reply

    Select*from EmployeeDetailTable
    where Name like ‘A%’ and length(Name)=5;

  4. Kratika
    2
    Reply

    SELECT *
    FROM EMPLOYEE
    WHERE NAME LIKE ‘A____’

    OR

    SELECT *
    FROM EMPLOYEE
    WHERE NAME LIKE ‘A%’ and length(NAME)=5

Leave an answer

Browse
Browse