Where clause syntactically correct, but giving nothing
I'm using this tutorial table called practice, with columns DEPTNO DNAME
LOC respectively.
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
Given this query
select * from practice where loc = 'DALLAS'
I get a row that I was expecting, but playing around, I also did this query,
select * from practice where('LOC') = 'DALLAS'
and I get nothing. I don't understand, this latter query is syntactically
valid, I got no exceptions, but still got an empty set result set. Does
where with () do anything special?
No comments:
Post a Comment