How do I find all files with the same name but different directories?


  • I have a table of file information (e.g. filename, directory, extension, size, etc.) and I'd like to find all files that share the same name but have different directories...

    I've gotten as far as being able to return all files that exist in the same directory, ordered next to each other for visual reference using this:

    SELECT FileName,Directory, COUNT(Directory) as dCount FROM v_files
    GROUP BY Directory,FileName
    ORDER BY FileName,Directory
    but I'd like to know if there's a way I can extend this to only display the files/directories where the file is represented in multiple directories.

    Friday, October 04, 2013 3:19 PM


All replies