title: Displaying multiple records of same type order by value and then order by type using mysql - is it even possible
body: <p><img src="https://i.stack.imgur.com/xZt10.png" alt="enter image description here"></p>
  
  <p>What I want to do is order by all the records by years experience so I get the highest number on top. Then take the vendor type of the top record and group all the records with that vendor type together. So if in the table picture 11 is the highest number and its vendor type is 1. It should group all the vendor types 1 together and still in descending order. Then list the other vendor types like in this case its 2 and its respective record(s) again in descending order.</p>
  
  <p>Following is what I am trying to do</p>
  
  <p>SELECT <code>usid</code> , <code>userskills</code>.<code>vid</code> , <code>appid</code> , <code>appversion</code> , <code>yearsexperience</code> , <code>vendor_type</code>
  FROM (
  <code>userskills</code>
  )
  JOIN <code>vendor</code> ON <code>vendor</code>.<code>vid</code> = <code>userskills</code>.<code>vid</code>
  WHERE <code>uid</code> = '734'
  ORDER BY <code>yearsexperience</code> DESC , <code>vendor_type</code> DESC </p>
  
  <p>so in this case I want the result as </p>
  
  <p><img src="https://i.stack.imgur.com/6PwGc.png" alt="enter image description here"></p>
  
  <p>i hope it makes sense</p>