Retrieve sequence of data from different columns.
- by janetsmith
Let's say I have a table containing following data:
| id | t0 | t1 | t2 |
| 1 | 4 | 5 | 6 |
| 2 | 3 | 3 | 2 |
| 3 | 6 | 4 | 5 |
| 4 | 4 | 5 | 5 |
I want to retrieve all the rows containing 4, 5, 6 (regardless the position of numbers in the tables), so row 1 & row 3 will be selected. How to do that with SQL query?