Help for select rows

Transact-SQL
1

i have this query

SELECT ICE_ODEMEBASLIK.* 
 ,ORT_DOSYALAR_kayitdamga AS DSY_kayitdamga
 ,HP.ID           HP_ID
 ,HP.planadi      HP_planadi
 ,KP.ID           KP_ID
 ,KP.planadi      KP_planadi
 ,ICE_CARIBANKA.ID      CBANKA_ID
 ,ICE_CARIBANKA.kod     CBANKA_kod
 ,ICE_CARIBANKA.hesapnr CBANKA_hesapnr
 ,ICE_CARIBANKA.subenr  CBANKA_subenr
 ,ICE_CARIBANKA.subeadi CBANKA_subeadi
FROM ICE_ODEMEBASLIK WITH (NOLOCK)  
LEFT JOIN ORT_PLAN AS HP WITH (NOLOCK)   ON ICE_ODEMEBASLIK.plankod      = HP.plankod
LEFT JOIN ORT_PLAN AS KP WITH (NOLOCK)   ON ICE_ODEMEBASLIK.karsiplankod = KP.plankod
LEFT JOIN (SELECT DISTINCT ORT_DOSYALAR.kayitdamga AS ORT_DOSYALAR_kayitdamga  FROM ORT_DOSYALAR  WITH (NOLOCK)   WHERE ORT_DOSYALAR.tablo = 6) AS DOSYA ON ICE_ODEMEBASLIK.kayitdamga=ORT_DOSYALAR_kayitdamga
LEFT JOIN ICE_CARIBANKA WITH (NOLOCK)   ON ICE_CARIBANKA.kayitdamga = ICE_ODEMEBASLIK.UQ_caribanka
WHERE 1 = 1 
 and ICE_ODEMEBASLIK.IOdurum   = -1
 and ICE_ODEMEBASLIK.odemetipi = 1
 and ICE_ODEMEBASLIK.pin      = 0
 and ICE_ODEMEBASLIK.belgetarihi >= CONVERT(DATETIME,'01.01.2023',103)
 and ICE_ODEMEBASLIK.belgetarihi <  CONVERT(DATETIME,'01.01.2024',103)
 AND ICE_ODEMEBASLIK.vadetarihi >= CONVERT(DATETIME, DATEADD(DAY,-1, GETDATE()), 103)
 AND ICE_ODEMEBASLIK.vadetarihi <  CONVERT(DATETIME,'01.01.2025',103)

I want to select 3 rows (example:odemeserino,plankod,hesapadi)

how can I do for this query ? thanks for help

[url=https://www.hizliresim.com/1g7ciuj][img]https://i.hizliresim.com/1g7ciuj.PNG[/img][/url]
2

hi

not able to understand you