Search found 17 matches

by Vertica_grm
Thu Jul 23, 2015 8:23 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

Re: Help with Code

Once I see it how it's done, I'll be able to do myself next time.
by Vertica_grm
Thu Jul 23, 2015 7:13 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

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.
by Vertica_grm
Thu Jul 23, 2015 5:46 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

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...
by Vertica_grm
Thu Jul 23, 2015 3:05 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

Re: Help with Code

Thank you JIm. You're the best! :D :D :D
by Vertica_grm
Wed Jul 22, 2015 10:04 pm
Forum: New to Vertica SQL
Topic: Declaring Variables in Vertica
Replies: 2
Views: 14122

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 . :(
by Vertica_grm
Wed Jul 22, 2015 9:55 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

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 ...
by Vertica_grm
Mon Jul 20, 2015 7:26 pm
Forum: New to Vertica SQL
Topic: Help with Code
Replies: 16
Views: 31330

Re: Help with Code

Thanks Jim,Really appreciate it.

That worked.

Go to advanced search