myPeopleSoft
PeopleSoft Community Network
cant we write subquery in select statement in peoplesoft queries
Cant we write sub queries in select statement of sql/views of peoplesoft as follows
select t1.*, (select count(id) from t as t2 where t2.id<=t1.id) as row_number from t as t1 order by Id Replies to This Discussion
-
Permalink Reply by Wendell Duppstadt on
-
Save your record as SQL View. The Query View type is for using the Query tool, which is a graphical editor more suited for those not familiar with SQL. It has certain limitations regarding non-standard SQL constructs.
In a SQL View, you can write down the query SQL directly.
-
PeopleSoft Jobs in US
Groups
© 2024 Created by Maisam Agha.
Powered by
