How to implement this SQL Script into LINQ Query?
SELECT (SELECT columnA FROM (SELECT columnA as A, columnB as B, ROW_NUMBER() OVER (ORDER BY columnA DESC) as count FROM tableA WHERE columnA = 'Name') x WHERE x.count = 1) as Answer1
It looks like you're new here. If you want to get involved, click one of these buttons!
Powered by Vanilla