How to write a query to show the details of a student from Students table whose name start with K?

Category: SQLHow to write a query to show the details of a student from Students table whose name start with K?
Editor">Editor Staff asked 2 years ago

How to write a query to show the details of a student from Students table whose
name start with K?

1 Answers
Editor">Editor Staff answered 2 years ago

Query:

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

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