0

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

Thanks,
Shyam

Stevoisiak
  • 23,794
  • 27
  • 122
  • 225
Shyam
  • 23
  • 1
  • 7

1 Answers1

2

You can.

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.

chilijoe
  • 23
  • 4