title: SQL- How to get two different column's values inside one column and two results?
body: <p>This title might be weird but I'm looking for a query which can do this:</p>
  <p>I have 1 line which looks like this in my table:</p>
  <p>Sensor_address | type_measure_1 | type_measure_2</p>
  <p>I would like to do a SQL query which can give me something like this:</p>
  <blockquote>
  <ul>
  <li><p>result 1 : Sensor_address = X | type_measure = type_measure_1</p>
  </li>
  <li><p>result 2 : Sensor_address = X (the same) | type_measure = type_measure_2</p>
  </li>
  </ul>
  </blockquote>
  <p>Is this possible in SQL?</p>