i have a table,it stores the name and criteria of files, one column contains the compatibility ID of the file...
name | URL | Size| Datetime|compatibility_ID|


now i want a query which retrieves the files according to the compatibility id

means first retrieve all compatible files after all the files which are not compatible....

i want this in one query, how i can make query n how i can combne? plz help...