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%";

Answer 1

→ 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