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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
11 | |
10 | |
7 | |
6 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |