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 4 years 6 Answers 1767 views Great Grand Master 0

Answers ( 6 )

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

  2. select name
    from table
    where leength(name) > 8

  3. SELECT * FROM EMPLOYEES
    WHERE LENGTH(FIRST_NAME) < 8

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

Leave an answer

Browse
Browse