New course! Every coder should learn Generative AI!
Try a free lesson0
Get the last name of all the customers whose the last name is made up of 4 letters. how can I do it?
5 Answers
+ 2
SELECT LAST NAME FROM TABLE WHERE LENGHT(LAST NAME) =4
0
you can also use like operator with 4 underscore.
select last_name from employees where last_name like '____';
0
use % after like condition
0
length option worked. 4 underscore with Like option didn't work.
thanks folks!
0
Roasekamal in which database you tried that? It works in oracle as tested myself.