MSSQL: ORDER BY the IN value list

Problem: Poredati rezultate SQL upita po nekom svojem poretku koji nema veze sa samim rezultatima sql upita.

Rješenje:

 

SELECT tbl_test.*
FROM tbl_test
INNER JOIN(
 VALUES
 (1,1),
 (3,2),
 (2,3),
 (4,4)
) AS dtbl_list (id, ordering) on tbl_test.id = dtbl_list.id
ORDER by dtbl_list.ordering

Source: https://stackoverflow.com/questions/866465/order-by-the-in-value-list

This entry was posted on Monday, March 5th, 2018 at 2:42 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.