79802029

Date: 2025-10-27 16:20:00
Score: 2
Natty:
Report link

Yes one way is using Over clause and Rank() to simulate with ties functionality:

select * from(

select Id, [Name], rank() over(order by Id) as R

from #tbl) A

where A.R = 1;

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Low reputation (0.5):
Posted by: gyousefi