So, I'm using a sql statement that works fine, but should return multiple rows, instead it returns the one in the top, is there any way I can return all the rows? My statement for the record:
select 'ID', TransactionId
FROM [dbo].[TransactionStatus]
where StatusId = '5'
and ValidFrom>'2020-02-27'