|
Emp_id
|
Emp_name
|
|
1
|
Suryagroops
|
|
2
|
Suresh
|
|
3
|
Mayank dixit
|
|
4
|
Suryagroops
|
|
5
|
Ramesh
|
|
6
|
Ramesh
|
|
7
|
Shalini
|
|
8
|
Sushil
|
Find
all Emp_Name started from‘s’ in the table
SELECT Emp_Name
FROM tbl_emp
WHERE (Emp_Name LIKE ’s %');
Result-
|
Emp_Name
|
|
Suryagroops
|
|
Suresh
|
|
Suryagroops
|
|
Shalini
|
|
Sushil
|
No comments:
Post a Comment