title: Union Select Only One Row
body: <p>I Have a query with Two Select Clause combines with UNION.I want to select only top first row. How can i do that Using Union ? </p>
  
  <pre><code>Select Fault,OccurredOn From ATMStatus Where Ticket=189703 // This Will retrieve single record as the primary key is applied
  Union 
  Select Fault,OccurredOn From ATMStatusHistory Where Resolved=0 AND Ticket=189703 Order By OccurredOn Desc
  </code></pre>