Posted By

djc on 09/01/10


Tagged

AudioVault


Versions (?)

AV Inventory tab


 / Published in: SQL
 

Segregowanie po ostatnio dodanym (czas, TLM)

  1. SELECT DISTINCT [TLM_Body], [File], [Cat], [Filetype], [Description], [EOMBegin], [Composer]
  2. FROM [Files]
  3. WHERE [Cat]='CMU' AND ([TLM_Body] < GETDATE()-0) AND
  4. [FileType] IN(1, 4) AND
  5. (([File] NOT LIKE '?*$#') AND ([File] NOT LIKE '?*$##')) ORDER BY [TLM_Body] DESC;

Report this snippet  

You need to login to post a comment.