As shown in Image I want to fetch distinct data. But due to different stage it is showing number of records. Please help me
Image
select distinct(d._System_objNBS), d._System_CurrentStage, d.CreatedDate,d.dateModified, d.fld016535 as Originator_Dept,e.fld004216,e.fld003984 from Obj122 d full join Obj81 e on d.UserCreatedId=e.UserId where d._System_CurrentStage NOT IN (‘Release’) and d.dateModified < ‘2024-06-30’
I have written above code
New contributor
Aniket Arulkar KPCL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.