SQL Interview Questions | 8 Characters in name

Question

Write a suitable query where you will collect the names of visitors in a conference who have less than 8 characters in their name. Also, separate the ones with a middle name.

(Hint- You can take appropriate column_names)

in progress 1
Dhruv2301 55 years 6 Answers 1830 views Great Grand Master 0

Answers ( 6 )

  1. Priyabrata017
    0
    Reply

    select ename from employee where ename len(ename)<8;
    Can you check it?

  2. Ognish
    0
    Reply

    select name
    from table
    where leength(name) > 8

  3. Amit
    0
    Reply

    SELECT * FROM EMPLOYEES
    WHERE LENGTH(FIRST_NAME) < 8

  4. Sai
    0
    Reply

    Select*from Table
    where LENGHT(Name)<8;

Leave an answer

Browse
Browse