Advertisements
Advertisements
Question
The name column of a table 'student' is given below.
| Name |
| Anu Sharma |
| Rohan Saini |
| Deepak Sing |
| Kannika Goal |
| Kunal Sharma |
Based on the information, find the output of the following queries:
→ Select name from student where name like "%a";
→ Select name from student where name like "%h%";
Very Short Answer
Advertisements
Solution
→ SELECT name FROM student WHERE name LIKE '%a';
| name |
|---|
| Anu Sharma |
| Kunal Sharma |
→ SELECT name FROM student WHERE name LIKE '%h%';
| name |
|---|
| Anu Sharma |
| Rohan Saini |
| Kunal Sharma |
shaalaa.com
Is there an error in this question or solution?
