I have a table with the following structure
| USERID | CONTACT | VALUE |
|---|---|---|
| 1 | LANDLINE | +12312322334 |
| 1 | MOBILE | +11234567890 |
| 1 | [email protected] | |
| 2 | LANDLINE | +12312322335 |
| 2 | MOBILE | +11234567899 |
| 3 | LANDLINE | +12312322336 |
| 3 | MOBILE | +11234567898 |
I want to have a result set of all users that have an email contact and list the result set as
| USERID | MOBILE | |
|---|---|---|
| 1 | +11234567890 | [email protected] |
Tried looking it up but can't remember the term of the needed query for thus, which made it hard for me find the solution.
Can anyone help and suggest the most efficient query for this scenario? This is for oracle db by the way