Hi All,

Specially who working on predictive analysis function using sql script in this process if we going call a generated procedure using our main table instead of that  we can create a view so we can easily analyzed the data so please find the code to proceed…

1.Main view whicg we going to call…

CREATE VIEW V_name  AS

SELECT column1 ,column2

FROM “schema”.”yourtable”;

2.View which going to analyze based on our requirement.

CREATE VIEW V_name1 AS

SELECT * FROM “schema”.”tablename”

WHERE table1 IN (

SELECT table1

FROM  “schema”.”tablename”

GROUP BY table1

HAVING (COUNT(table1 ) > 1)

)

Regards

Rupendra

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply