Question

How to write an SQL query to find students' names start with 'A'?

Answer 1

We can write the following query to get the student details whose name starts with A:

SELECT * FROM student WHERE stud_name like 'A%';  

Here is the demo example where we have a table named student that contains two names starting with the 'A' character.