Write a SQL query to find the names of employees that begin with S

Question

Hi!!

Can someone tell me how to write the query for the above statement?

Comments

how to get column alies as worker

Answer 1

To display the name of the employees that begin with ‘S’, type in the below command:

SELECT * FROM Table_name WHERE EmpName like 'S%'

Comments

Yeah that is cool for the names where only first letter is capital but what to do when there are multiple same characters in the same string. Like in this case:-

CREATE TABLE emp_salary(

    emp_id INT PRIMARY KEY ,

    emp_name VARCHAR(10),

    salary INT ,

    emp_age INT

);

INSERT INTO emp_salary VALUES(1,"Raghu",100000,25);

INSERT INTO emp_salary VALUES(8,"Arnav",100000,25);

INSERT INTO emp_salary VALUES(9,"ascsaAjbsj",100000,25);

INSERT INTO emp_salary VALUES(2,"Rajeev",250000,28);

INSERT INTO emp_salary VALUES(3,"Ranvijay",80000,22);

INSERT INTO emp_salary VALUES(4,"Prince",90000,23);

INSERT INTO emp_salary VALUES(5,"Nikhil",82000,22);

INSERT INTO emp_salary VALUES(6,"DELL",54448,22);

INSERT INTO emp_salary VALUES(7,"OPOPPO",748400,24);

SELECT * FROM emp_salary WHERE emp_name LIKE "A%";

Here it will return both Arnav and ascsaAjbsj. What to do?

Answer 2

Select ename
From emp
Where ename like"s%";