I am trying to generate a SQL query where I can select more than one "TOP 1".
For instance, I might want the top 1 from one column and the top 1 from another column, both being in different rows.
SELECT TOP 1 'Column1' as x, TOP 1 'Column3' as y, Z FROM TableA WHERE Z LIKE '%str%'
Please let me know if this requires more explanation. Thanks in advance!