Can we have Separate where clause for separate column accessing the same table

[Nishant Gaurav]

Hi All,

Here is the scenario i want a solution for.

i have two columns col1 and col2 which needs to access the result of same table whose col(say time col) is required for fetching the result.
while i want the output of col1 when time col value is equal to some value say 30 and col2 to be when time col <=30.
Please let me know if this can be achieved.
Thanks and Regards

[zorgi]

You might want to have a look at UNION