Pinned topic TDM select query in selection criteria
Is there any other way to do it???
Raviteja GV 27000699B82 Posts
Re: TDM select query in selection criteria2013-04-18T06:07:05ZThis is the accepted answer. This is the accepted answer.
To extract distinct column data from table, you have to write a subquery in table specifications of access definition
For example: Select * from table_name where row_id IN ( SELECT row_id FROM
,row_number() over (partition by column1||'~'||column2||'~'||column3 ) rowcnt1
FROM table_name TBL)A
WHERE rowcnt1 = 1)
whatever i have highlighted that is default statement in SQL area, we have to write the remaining SQL statement to achieve our expected result.