471,120 Members | 1,551 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,120 software developers and data experts.

convert this query into storeprocedure

1
SELECT org_id, count(distinct entry_id) as entry_point, sum(total_device) as total_device, sum(active_device) as active_device,
sum(total_tablet) as total_tablet, sum(active_tablet) as active_tablet,
sum(total_desktop) as total_desktop, sum(active_desktop) as active_desktop, sum(in_cnt) as din_cnt, sum(out_cnt) as dout_cnt
FROM dashboard_device GROUP BY org_id
Mar 12 '18 #1
1 1967
Frinavale
9,735 Expert Mod 8TB
Use the Create Procedure statement to create your procedure...

See this documentation for the CREATE PROCEDURE and CREATE FUNCTION Syntax.
Mar 12 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Michel Walsh | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.