See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.
WITH CTE AS ( SELECT a.GalleryID GalleryID_A, a.GalleryTitle, a.GalleryDate, b.*, ROW_NUMBER() OVER (PARTITION BY a.GalleryID, a.GalleryTitle, a.GalleryDate ORDER BY b.MediaThumb DESC) AS Rn FROM Media b INNER JOIN Galleries A ON a.GalleryID = b.GalleryID ), CTE2 AS ( SELECT a.GalleryID GalleryID_A, a.GalleryTitle, a.GalleryDate, b.*, 1 Rn FROM Media b LEFT OUTER JOIN Galleries A ON a.GalleryID = b.GalleryID ) SELECT * FROm CTE where rn = 1 UNION ALL SELECT * FROM CTE2 WHERE rn = 1 and galleryid is null ORDER BY MediaID DESC
|How to implement a row column color change using Dev Express Quantum Grid in Delphi||3||17|
|Dynamic Database connection in SSIS 2012||11||44|
|SQL Select Query problems||10||37|
|Following an example - removing duplicate strings||4||24|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
15 Experts available now in Live!