Viewing 15 posts - 181 through 195 (of 210 total)
WITH
n AS...
March 16, 2018 at 4:08 am
I'm having problems using the MaxDate function in SQL and wondered if...
January 2, 2018 at 10:25 am
Following are the values in main table.
Name ...
December 24, 2017 at 9:02 am
Can you kindly provide more details along with sample data and also what you mean by I'm getting the result of only first case?
Saravanan
December 24, 2017 at 8:39 am
Can you kindly elaborate how you got count=3 and count=1?
Saravanan
December 18, 2017 at 10:32 pm
December 12, 2017 at 11:18 pm
Hi,
You are right. I made a small mistake.Below query gives accurate results. But you can Jeff Moden query as his query is always efficient.
December 11, 2017 at 7:42 am
Hi ,
Your SQL formatting looks very good. What tools your using for paste the query with color and proper formatting.
Solution:
WITH cte
AS (SELECT
...
December 10, 2017 at 8:14 am
Hi,
Welcome to SQL Central
create table calendar
(
[date] date,
value int);
insert into calendar values ('11/1/2017',123);
insert into calendar values ('11/2/2017',130);
insert into calendar values ('11/3/2017',140);
December 9, 2017 at 12:13 am
Thanks John. I posted the test data similar to what we got in Hive results(test data is coming like this may be due to hive nature as there is no...
December 8, 2017 at 8:44 am
Thanks Thorn and John . Will test with more test data and get back to you guys.
Regards,
Saravanan
December 6, 2017 at 5:48 am
December 6, 2017 at 4:49 am
That's good question I haven't got records like that . But I would like to exclude that records as well.
Regards,
Saravanan
December 6, 2017 at 3:21 am
Viewing 15 posts - 181 through 195 (of 210 total)