From the following table, write a SQL query to find those rows where col1 contains the character percent ( % ). Return col1

hamza

Save to bookmark

2022-05-18

133

From the following table, write a SQL query to find those rows where col1 contains the character percent ( % ). Return col1.

Sample table: testtable

col1
--------------------------
A001/DJ-402\44_/100/2015
A001_\DJ-402\44_/100/2015
A001_DJ-402-2014-2015
A002_DJ-401-2014-2015
A001/DJ_401
A001/DJ_402\44
A001/DJ_402\44\2015
A001/DJ-402%45\2015/200
A001/DJ_402\45\2015%100
A001/DJ_402%45\2015/300
A001/DJ-402\44

Sql programming,

All Answers

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

SELECT *
FROM testtable
WHERE col1 LIKE '%/%%' ESCAPE'/';

Output of the Query:

col1
A001/DJ-402%45\2015/200
A001/DJ_402\45\2015%100
A001/DJ_402%45\2015/300

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)

From the following table, write a SQL query to find those rows where col1 contains the character percent ( % ). Return col1

All Answers

Similar questions

need a help?

find thousands of online teachers now