SQL Interview question
Question
Write a query to get all the student with name length 10, starting with K and ending with z
solved
3
SQL
55 years
25 Answers
2966 views
Contributor 0
Answers ( 25 )
select name from student
where length(name)=10 and name like ‘K%’ and name like ‘%z’
select name from student where len(name)=10 and name like ‘K%’ and name like ‘%z’
Sorry it a private answer.
select name from student where length(name)=10 and lower(name) like ‘k%z’
SELECT name
FROM student
WHERE LEN(name)=10
AND
name LIKE ‘K%’ AND name LIKE ‘%z’ ;
select name from student
where length(name)=10 and lower(name) like ‘k%z’
Select name from student where length(name) = 10 and upper(name) Like ‘K%Z’
select name
from student
where length(name) = 10 and
upper(name) like ‘K%Z’
select name from student where len(name)=10 and lower(name)=’k%z’;
SELECT name FROM students
WHERE LENGTH(name) = 10 AND name LIKE ‘K%z’
Select * from Students
Where Name like ‘K________z’
SELECT name FROM student
WHERE length(name)=10 and UPPER (name) like ‘K%Z’
select name from student where (name like ‘K%z’) and (length(name)=10);
SELECT name FROM student
WHERE length(name) =10 AND lower(name) LIKE ‘k%z’
select name from student
where length(name)=10 and lower(name) like ‘k%’ and lower(name) like ‘%z’;
select name,
from student,
where length(name) = 10 and lower(name) like ‘k%’ or lower(name) like ‘%z’
Sorry it a private answer.
SELECT name FROM student WHERE LENGTH(name)=10 AND name LIKE ‘K%z’
select name
from student
where length(name)=10 and lower(name) like ‘k%z’;
Write a query to get all the student with name length 10, starting with K and ending with z
SELECT name
FROM student
WHERE length(name)=10 AND LOWER(name)=”k%z”;
SELECT name
FROM student
WHERE LENGTH(name) = 10 AND name LIKE ‘K%z’
SELECT name
FROM student
WHERE length(name)=10 AND LOWER(name)=”k%z”;
Sorry it a private answer.
Select name FROM student WHERE length(name)=10 AND LOWER(name) LIKE “k%z”
SELECT name
FROM student
WHERE length(name)=10 AND LOWER(name) LIKE ‘k%z’