Write a SQL query to find all the student names Nitin in a table
Question
Table is student
column is name
Make sure that you cover all the corner cases
solved
2
SQL
55 years
25 Answers
2879 views
Contributor 1
Answers ( 25 )
select name from student
where name like ‘Nitin%’ or name like ‘%Nitin’ or name like ‘%Nitin%’
You need to optimize it
Sorry it a private answer.
Think more on the corner cases
select name from student where lower(name) like ‘%nitin%’
Awesome 🙂
Ohhh. Finally, find what was my mistake
select name
from student
where lower(name)
like ‘%nitin%’ ;
select name from student
where lower(name) like ‘%nitin%’
Select name from student where upper(name)
Like % NITIN %
select name
from
select name from student where lower(name) like ‘%nitin%’;
SELECT name ILIKE ‘%nitin%’ FROM student
SELECT Name from Student
WHERE UPPER(Name) like ‘%NITIN%’;
select name from student where name like ‘%Nitin%’;
select name from student where lower(name) like ‘%nitin%’
select name,
from student,
where lower(name) like ‘%nitin%’
SELECT name FROM student
WHERE lower(name) LIKE ‘%nitin%’
SELECT name FROM student WHERE LOWER(name) LIKE ‘%nitin%’
select name
from student
where lower(name) like ‘%nitin%’;
SELECT name
FROM student
WHERE LOWER(name) LIKE “%Nitin%”
SELECT name
FROM student
WHERE LOWER(name) LIKE ‘%nitin%’
SELECT name
FROM student
WHERE LOWER(name) LIKE “%Nitin%”
Select name FROM student WHERE LOWER(name) LIKE “%Nitin%”
SELECT name
FROM student
WHERE LOWER(name)
LIKE %nitin%
select name from student where lower(name) like ‘%nitin%’