New answers tagged

0 votes

How to get row number for jobid via SQL?

The typical pattern to use this is for deduplication; Here the row_number() function goes into the subselect. in the code below, subselect has alias: a SELECT a.JobID FROM ( SELECT TOP 5 JobID ,...
Jonas Lamberty's user avatar

Top 50 recent answers are included