1
Answer

Replace Max function to get 1 record

Ramco Ramco

Ramco Ramco
4w
157
1

Hi

 IN below code i want only to get 1 record . I dont want to use Max

(Select "Location" from OLCT where "Code" = (Select Max("LocCode") from DPO1 where "DocEntry"=T0."DocEntry")) "Location"

Thanks

Answers (1)
Next Recommended Forum