DB2 - select multiple key values for common primary key
<p>I have following data</p>

<h2>ID KEY Value</h2>

<p>1  K1   1</p>

<hr>

<p>1  K2   2</p>

<hr>

<p>2  K1   3</p>

<hr>

<p>2  K2   4</p>

<hr>

<p>3  K1   5</p>

<hr>

<p>3  K2   6</p>

<p>I need to do a select from above table data in DB2 to display like following  -</p>

<h2>ID Key1 Value Key2 Value</h2>

<p>1   K1    1    K2    2</p>

<hr>

<p>2   K1    3    K2    4</p>

<hr>

<p>3   K1    5    K2    6</p>