Search found 17 matches
- Thu Jul 23, 2015 8:23 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
Once I see it how it's done, I'll be able to do myself next time.
- Thu Jul 23, 2015 7:13 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
because this dataset is a result of a subquery and I'm not able to figure out how to write the Select which would pick only the max and min of the last column.
- Thu Jul 23, 2015 5:46 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
could I please bother you with one last? I have arranged my dataset in following format ID1 ID2 EventATime Event SID InteractionTime InteractionNumber 3335989 887582837 5/31/2014 23:53 A 1186276 (null) (null) 3335989 887582837 5/31/2014 23:53 I 1186276 5/10/2014 0:52 1 3335989 887582837 5/31/2014 23...
- Thu Jul 23, 2015 3:05 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
Thank you JIm. You're the best!
- Wed Jul 22, 2015 10:04 pm
- Forum: New to Vertica SQL
- Topic: Declaring Variables in Vertica
- Replies: 2
- Views: 14265
Re: Declaring Variables in Vertica
Thanks JIM,
So i use a SQL client. DB visualizer to run all my queries and when I use /set there, it pops up a window asking for the input. It's very annoying not to be able to use queries with variables on that tool .
So i use a SQL client. DB visualizer to run all my queries and when I use /set there, it pops up a window asking for the input. It's very annoying not to be able to use queries with variables on that tool .
- Wed Jul 22, 2015 9:55 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
If I have result set from a subquery as UserID ColumnA Column B Percent 1 1 5 0.2 2 2 5 0.4 3 1 4 0.25 7 0 1 0 8 0 1 0 How do I add another Column (5th one below) which is basically SUM(ColumnA)/SUM(COLUMNB) UserID ColumnA Column B % Group AVG Optimum 1 2 5 0.4 0.3125 Yes 2 2 5 0.4 0.3125 Yes 3 1 4 ...
- Mon Jul 20, 2015 7:26 pm
- Forum: New to Vertica SQL
- Topic: Help with Code
- Replies: 16
- Views: 32283
Re: Help with Code
Thanks Jim,Really appreciate it.
That worked.
That worked.