I have very simple problem that I can’t solve. I need to do something like this:
select distinct * from (1, 1, 1, 2, 5, 1, 6).
Anybody can help??
Edit
The data comes as a text file from one of our clients. It’s totally unformatted (it’s a single, very long line of text), but it may be possible to do so in Excel. But it’s not practical for me, because I will need to use these values in my sql query. It’s not convenient to do so every time I need to run a query.