Question

How to write a query to show the details of a student from Students table whose

name start with K?

Answer 1

Query:

SELECT * FROM Student WHERE Student_Name like ‘K%’;

Here ‘like’ operator is used to perform pattern matching.