New to Vertica SQL

Moderator: NorbertKrupa

New Topic

70 topics

Topics

Replies

Views

Last post

SQL formatter or prettyfier?

Last post by fomenkovoleg « Tue Aug 14, 2018 9:56 am
Replies: 4
by dbmsuser7 » Tue Jul 15, 2014 1:48 pm

4 Replies

49083 Views

Last post by fomenkovoleg
Tue Aug 14, 2018 9:56 am
NULL AS 'string' option of the copy command does not work with fcsvparser()

Last post by sKwa « Mon Aug 14, 2017 7:16 pm
Replies: 3
by JimKnicely » Thu Jan 19, 2017 2:43 pm

3 Replies

18935 Views

Last post by sKwa
Mon Aug 14, 2017 7:16 pm
Earliest date of the latest ID

Last post by JimKnicely « Thu Jul 20, 2017 7:00 pm
Replies: 1
by dazz » Thu Jul 20, 2017 5:58 pm

1 Replies

11756 Views

Last post by JimKnicely
Thu Jul 20, 2017 7:00 pm
What resource pool did query use?

Last post by JimKnicely « Tue Apr 25, 2017 8:27 pm
Replies: 1
by Julie » Tue Apr 25, 2017 7:19 pm

1 Replies

12120 Views

Last post by JimKnicely
Tue Apr 25, 2017 8:27 pm
Transactions

Last post by JimKnicely « Thu Apr 06, 2017 4:40 am
Replies: 1
by SQLTougherGuy » Tue Apr 04, 2017 5:50 pm

1 Replies

13197 Views

Last post by JimKnicely
Thu Apr 06, 2017 4:40 am
Extract string items into rows?

Last post by debfawn « Tue Mar 07, 2017 8:32 pm
Replies: 2
by debfawn » Tue Mar 07, 2017 7:42 pm

2 Replies

13530 Views

Last post by debfawn
Tue Mar 07, 2017 8:32 pm
How to use ERROR TOLERANCE parameter in Vertica SQL?

Last post by JimKnicely « Thu Feb 23, 2017 3:41 pm
Replies: 1
by atul.pdm@gmail.com » Wed Feb 22, 2017 5:56 pm

1 Replies

12385 Views

Last post by JimKnicely
Thu Feb 23, 2017 3:41 pm
Question about Normalize function

Last post by JimKnicely « Fri Jan 13, 2017 2:12 pm
Replies: 1
by beth » Thu Jan 12, 2017 6:01 pm

1 Replies

12419 Views

Last post by JimKnicely
Fri Jan 13, 2017 2:12 pm
how to use the datepart function to calculate the count at specific time?

Last post by JimKnicely « Tue Nov 22, 2016 9:50 pm
Replies: 1
by atul.pdm@gmail.com » Tue Nov 22, 2016 7:43 pm

1 Replies

14327 Views

Last post by JimKnicely
Tue Nov 22, 2016 9:50 pm
How to print the output of select query Horizontally?

Last post by JimKnicely « Mon Nov 21, 2016 3:29 pm
Replies: 1
by atul.pdm@gmail.com » Mon Nov 21, 2016 2:38 pm

1 Replies

13164 Views

Last post by JimKnicely
Mon Nov 21, 2016 3:29 pm
How to calculate the median

Last post by JimKnicely « Fri Nov 18, 2016 2:02 pm
Replies: 1
by atul.pdm@gmail.com » Fri Nov 18, 2016 1:31 pm

1 Replies

14491 Views

Last post by JimKnicely
Fri Nov 18, 2016 2:02 pm
Count Distinct on more than one column?

Last post by JimKnicely « Tue Sep 27, 2016 2:28 pm
Replies: 1
by Brett » Tue Sep 27, 2016 2:09 pm

1 Replies

15337 Views

Last post by JimKnicely
Tue Sep 27, 2016 2:28 pm
Convert DB2 date fields to Vertica format

Last post by JimKnicely « Thu Jul 14, 2016 2:36 pm
Replies: 1
by beth » Thu Jul 14, 2016 2:08 pm

1 Replies

14247 Views

Last post by JimKnicely
Thu Jul 14, 2016 2:36 pm
create table like another including segmentation

Last post by l_monato « Tue May 03, 2016 4:44 am

by l_monato » Tue May 03, 2016 4:44 am

0 Replies

12462 Views

Last post by l_monato
Tue May 03, 2016 4:44 am
Sample Vertica SQL with the inputs from an application

Last post by rsaveetha « Fri Apr 22, 2016 12:18 pm
Replies: 3
by rsaveetha » Mon Apr 11, 2016 7:22 am

3 Replies

15891 Views

Last post by rsaveetha
Fri Apr 22, 2016 12:18 pm
Query for de duplication

Last post by rsaveetha « Fri Apr 22, 2016 12:17 pm

by rsaveetha » Fri Apr 22, 2016 12:17 pm

0 Replies

10629 Views

Last post by rsaveetha
Fri Apr 22, 2016 12:17 pm
SQL median function

Last post by JimKnicely « Thu Apr 21, 2016 2:41 am
Replies: 1
by usli06 » Wed Apr 20, 2016 10:12 pm

1 Replies

12713 Views

Last post by JimKnicely
Thu Apr 21, 2016 2:41 am
Referencing a column alias in the same select list

Last post by jane « Thu Apr 07, 2016 4:51 pm
Replies: 3
by jane » Wed Apr 06, 2016 7:09 pm

3 Replies

19085 Views

Last post by jane
Thu Apr 07, 2016 4:51 pm
getting back id generated via autoincrement

Last post by JimKnicely « Wed Mar 09, 2016 9:06 pm
Replies: 1
by akina86 » Wed Mar 09, 2016 4:52 pm

1 Replies

13394 Views

Last post by JimKnicely
Wed Mar 09, 2016 9:06 pm
Explain how to

Last post by sowe « Fri Dec 11, 2015 1:15 pm
Replies: 2
by sowe » Wed Dec 09, 2015 1:01 pm

2 Replies

17175 Views

Last post by sowe
Fri Dec 11, 2015 1:15 pm
Question about running multiple SQL scripts with vsql

Last post by mikep17 « Sun Dec 06, 2015 5:13 am
Replies: 6
by mikep17 » Fri Dec 04, 2015 3:18 pm

6 Replies

22717 Views

Last post by mikep17
Sun Dec 06, 2015 5:13 am
initializing column to NULL in SELECT

Last post by roger « Sat Oct 31, 2015 10:10 am
Replies: 7
by Beg1nner » Fri Oct 23, 2015 10:00 pm
1

2
7 Replies

30854 Views

Last post by roger
Sat Oct 31, 2015 10:10 am
Sum by category

Last post by JimKnicely « Wed Oct 07, 2015 11:07 pm
Replies: 2
by mgbizintel » Mon Oct 05, 2015 9:50 pm

2 Replies

14530 Views

Last post by JimKnicely
Wed Oct 07, 2015 11:07 pm
Encapsulation in Vertica

Last post by Beg1nner « Thu Jul 30, 2015 2:42 pm

by Beg1nner » Thu Jul 30, 2015 2:42 pm

0 Replies

12219 Views

Last post by Beg1nner
Thu Jul 30, 2015 2:42 pm
Calculating difference between two timestamps

Last post by id10t « Tue Jul 28, 2015 9:05 am
Replies: 4
by manialluri » Mon Jul 27, 2015 9:17 pm

4 Replies

19395 Views

Last post by id10t
Tue Jul 28, 2015 9:05 am

New Topic

70 topics

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum