Thursday, January 9, 2014

How to fetch data using simple select query in Netezza

Hi All,

 As everyone knows that we can get the data using simple query like below for many databases.

select * from <databasename>.<tablename> ;

For Netezza:

In Netezza,we use double dot operator(..) in between databasename and tablename just like below.

select * from <databasename>..<tablename> ;

No comments:

Post a Comment