Problem: Poredati radne naloge po godini i broju ako broj radnog naloga ima sintaksu “broj/godina”
Rješenje: ORDER BY RIGHT(broj_naloga,4) DESC, LEFT(broj_naloga,len(broj_naloga)-5) DESC
This entry was posted on Monday, January 7th, 2013 at 10:54 amand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.