Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
168

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

Labels in this area