title: to get 1st record with conditions in sql
body: <p>i have table with 100 columns name.
  I want to get 1st record of each item with specific conditions</p>
  
  <p>I have column name 
  Model_Name( car model name about 7 to 8 different models)</p>
  
  <p>Credit_flag(Y/N)</p>
  
  <p>Private_Offer(Y/N)</p>
  
  <p>Cash_back(some value or blank)</p>
  
  <p>Bonus_cash(some value or blank)</p>
  
  <p>Now If i want to get 1st record for each model</p>
  
  <p>where Credit_flag is equal to yes</p>
  
  <p>where private_offer is equal to yes</p>
  
  <p>where cash_back is equal to some value not blank</p>
  
  <p>where Bonus_cash is equal to some value not blank</p>
  
  <p><img src="https://i.stack.imgur.com/4odIw.png" alt="Cars"></p>