Select Query in DB2

ashu000 · #1 (**permalink**) 06-22-11, 05:12

Hi All,

I have to create a query which will return result from a table. I need to show all the records but top row will must show what user has searched in the table.

I tried a query but it is returning only 1 row that is the one user has searched and if I try to use this query with order by, it is not working.

Kindly suggest if someone is having any idea on this.

Thanks in advance.

tonkuma · #2 (**permalink**) 06-22-11, 05:28

If "what user has searched in the table" was same as the result of this query,

Code:

SELECT ...
 FROM  <the table>
 WHERE <some conditions>

your required query may look like...

Code:

SELECT ...
 FROM  <the table>
 ORDER BY
       CASE
       WHEN <some conditions> THEN
            0
       ELSE 1
       END

ashu000 · #3 (**permalink**) 06-22-11, 06:07

Hi,

It is done using UNION keyword. Using UNION, I used two select queries to get required results.

Thanks.

Internet Services

Web Development

Digital Marketing

Consumer Tech