SQL query and subquery on AWS redshift throwing error

Question

When I tried to query a table using this SQL code on AWS redshift:

SELECT aa.* 
FROM 
    (SELECT * FROM abc.xyz_tab1) AS aa 
WHERE 
    aa.claimnumber="H02799";

I got the following error:

ERROR: 42703: column "h02799" does not exist in aa

I even tried:

SELECT aa.* 
FROM 
    (SELECT * FROM abc.xyz_tab1) aa 
WHERE aa.claimnumber = "H02799";

SELECT aa.* 
FROM 
    (SELECT * FROM abc.xyz_tab1) AS aa 
WHERE claimnumber = "H02799";

SELECT aa.* 
FROM 
    (SELECT * FROM abc.xyz_tab1) aa 
WHERE claimnumber = "H02799";

But got the same error.

What have I missed or doing wrong here?

I am not sure, but this worked. I wonder is AWS redshift sensitive towards single or double quotes??? — LeMarque
– LeMarque, Commented Jul 3, 2019 at 9:47
I'm not familiar with redshift, but in ANSI SQL double quotes are used for object identifiers, and single quotes for literal strings. — HoneyBadger
– HoneyBadger, Commented Jul 3, 2019 at 9:50

user330315 · Accepted Answer · 2019-07-03 10:34:23Z

3

In SQL, string constants need to be enclosed in single quotes '. Double quotes are used for identifiers (column, table names).

So you need:

WHERE aa.claimnumber = 'H02799';

answered Jul 3, 2019 at 10:34

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query and subquery on AWS redshift throwing error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related