Register Now

By registering, you agree to the terms of service and Privacy Policy.

Login

Forget

Lost Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

x

Login

Forget

Register Now

It will take less than 1 minute to register for lifetime. Bonus Tip - We don't send OTP to your email id Make Sure to use your own email id for free books and giveaways

Create an account
x
You can use WP menu builder to build menus
Ask a Question
0
  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

The Data Monk

  • Buy Your e-book
  • Contact Us
  • About Us
    • Pricing
    • Terms and Conditions
    • Cancellation/Refund Policy
    • PRIVACY POLICY

About raoankit1904 Newbie

raoankit1904
  • Registered: October 12, 2020

User Stats

  • Questions ( 0 )
  • Answers ( 1 )
  • Asked Questions ( 0 )
  • Posts ( 0 )
  • Comments ( 0 )
  • Best Answers ( 0 )
  1. Past 7 days Rolling Count distinct

    raoankit1904
    raoankit1904 Newbie
    0
    October 12, 2020 at 1:19 pm
    select date, lag(count(distinct id),7) over (order by date)

Products

  • Mentorship Program for Analytics interview 1 Month Analytics Mentorship Program ₹11500 Original price was: ₹11500.₹9999Current price is: ₹9999.
  • The Data Monk e-book bundle The Data Monk 23 e-book bundle ₹6900 Original price was: ₹6900.₹1999Current price is: ₹1999.
  • Most asked Analytics Interview Questions 2200 Most Asked Analytics Interview Questions ₹7999 Original price was: ₹7999.₹1999Current price is: ₹1999.
  • Ace The SQL Interview Ace The SQL Interview | 200+ Most Asked SQL Questions in Top Product Based Companies ₹1299 Original price was: ₹1299.₹799Current price is: ₹799.
  • 550 SQL Interview Questions to crack Any Analytics interview 550 SQL Interview Questions to crack Any Analytics interview ₹999 Original price was: ₹999.₹499Current price is: ₹499.

Stats

  • Questions ( 1784 )
  • Answers ( 2722 )
  • Best Answers ( 92 )
  • Users ( 25458 )
Copyright 2020 Ask me | By 2code
  • Login
  • Sign Up
Forgot Password?
Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.
body::-webkit-scrollbar { width: 7px; } body::-webkit-scrollbar-track { border-radius: 10px; background: #f0f0f0; } body::-webkit-scrollbar-thumb { border-radius: 50px; background: #dfdbdb }