Guest User

Untitled

a guest
Jan 22nd, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. Select SUM(power/td) from sometable where time = GetDate() order by time DESC;
  2.  
  3. select sum(power/td)
  4. from mytable
  5. WHERE year(time) = year(getdate())
  6. AND month(time) = month(getdate())
  7. AND day(time) = day(getdate())
Add Comment
Please, Sign In to add comment