0

Display the enames who have more than two ' l ' or exactly three ' l ' in their enames from table emp?

👍

25th Sep 2017, 12:01 AM
vikky loganathan
vikky loganathan - avatar
2 Respuestas
+ 1
select enames from emp where enames like 'l%' selext enames from emp where enames like 'lll' Something like this. please lookup the correct syntax. Just wrote down what was in my mind. https://www.tutorialspoint.com/sql/sql-like-clause.htm
25th Sep 2017, 5:20 AM
sneeze
sneeze - avatar
+ 1
Just adding a point after @Sneeze, you can use '%' to include any match. e.g. SELECT enames FROM emp WHERE enames LIKE '%ll%' OR enames LIKE '%lll%'; I hope I get it right, was it lower 'L' or upper 'i'?, either way I guess you get the point. Hth, cmiiw
25th Sep 2017, 5:51 AM
Ipang