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
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!