SELECT
M.Id
,M.RebookedMeetingId
,M.BookingTime
,M.StartTime
,M.EndTime
,M.Status
,M.MeetingPurpose
,MT.Name as MeetingType
,M.CreatedBy as Booker
,TA.Initials as TiedAgent
,C.Name as Center
,CUS.CustomerNumber
,ADR.ZipCode
from (
SELECT
M.Id
,M.RebookedMeetingId
,M.BookingTime
,M.StartTime
,M.EndTime
,M.Status
,M.MeetingPurpose
,MT.Name as MeetingType
,M.CreatedBy as Booker
,TA.Initials as TiedAgent
,C.Name as Center
,CUS.CustomerNumber
,ADR.ZipCode
,row_number() over (partition by cus.customernumber
order by m.bookingtime asc) as rn
FROM "MBW-DB"."dbo"."Meeting" M
join "MBW-DB"."dbo"."TiedAgent" TA on M.TiedAgentId = TA.id
join "MBW-DB"."dbo"."MeetingType" MT on M.meetingTypeId = MT.id
join "MBW-DB"."dbo"."Center" C on TA.centerId = C.Id
join "MBW-DB"."dbo"."Customer" CUS on M.customerId = CUS.Id
join "MBW-DB"."dbo"."Address" ADR on M.addressId = ADR.Id
WHERE M.MeetingPurpose = 'SalesMeeting'
) as x
where x.rn=1
order by BookingTime asc
SELECT Id
,RebookedMeetingId
,BookingTime
,StartTime
,EndTime
,Status
,MeetingPurpose
, MeetingType
, Booker
, TiedAgent
, Center
,CustomerNumber
,ZipCode
from (
SELECT M.Id
,M.RebookedMeetingId
,M.BookingTime
,M.StartTime
,M.EndTime
,M.Status
,M.MeetingPurpose
,MT.Name as MeetingType
,M.CreatedBy as Booker
,TA.Initials as TiedAgent
,C.Name as Center
,CUS.CustomerNumber
,ADR.ZipCode
,row_number() over (partition by cus.customernumber
order by m.bookingtime asc) as rn
FROM "MBW-DB"."dbo"."Meeting" M
join "MBW-DB"."dbo"."TiedAgent" TA on M.TiedAgentId = TA.id
join "MBW-DB"."dbo"."MeetingType" MT on M.meetingTypeId = MT.id
join "MBW-DB"."dbo"."Center" C on TA.centerId = C.Id
join "MBW-DB"."dbo"."Customer" CUS on M.customerId = CUS.Id
join "MBW-DB"."dbo"."Address" ADR on M.addressId = ADR.Id
WHERE M.MeetingPurpose = 'SalesMeeting'
) as x
where x.rn=1
order by BookingTime asc
SELECT DISTINCT
M.Id
,M.RebookedMeetingId
,M.BookingTime
,M.StartTime
,M.EndTime
,M.Status
,M.MeetingPurpose
,MT.Name as MeetingType
,M.CreatedBy as Booker
,TA.Initials as TiedAgent
,C.Name as Center
,CUS.CustomerNumber
,ADR.ZipCode