19. Display all clients whose name begins with the letter J or contains the let

19. Display all clients whose name begins with the letter J
or contains the letter M anywhere or contains E as the third
letter.

Question Posted / deepakgunji

2 Answers
5435 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or co..

Answer / saiprasannach89

select cname from client where lower(ename) like 'j%' or lower(cname) like '%m%' or select cname from emp where lower(cname) like 's%' or lower(cname) like '___e%';

Is This Answer Correct ?

0 Yes

0 No

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or co..

Answer / suresh babu

select client_name from client where client_name like 'j%'
or client_name like '%M%' or client_name like '___E%';

Is This Answer Correct ?

1 Yes

1 No

Post New Answer