Replace Max function to get 1 record

Ramco Ramco

1y746SQL

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar1y ago

Accepted answer

Hello Ramco,

You can use this one,

(SELECT TOP 1 "Location" 
 FROM OLCT 
 WHERE "Code" = (SELECT "LocCode" 
                 FROM DPO1 
                 WHERE "DocEntry" = T0."DocEntry")
) AS "Location"