return 6 out of 7

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm trying to return records starting with the most relevant desending to the lest relevant bast on 7 veriables. 

How do you write a SQL statment to return a bunch of records and order by matching of the veriables. 

so return 7 out of 7 first but then any of the 6 out of the 7 and then any of the 5 out of 7. 

i'm only been doing this for a year so any help would be appreciated. 

mark