Search found 1 match
- Sat Aug 06, 2016 7:36 pm
- Forum: Vertica SQL
- Topic: Assignment of query output to a variable
- Replies: 1
- Views: 16138
Assignment of query output to a variable
Hi, Can we set the output of the query to a variable like, CNT=SELECT COUNT(*) FROM DATABASENAME.TABLENAME; I know, we have \set CNT 'SELECT COUNT(*) FROM DATABASENAME.TABLENAME' \echo :CNT SELECT COUNT(*) FROM DATABASENAME.TABLENAME But i need to output of the query in the CNT, i need the number va...