How can i execute query like "SELECT 1=1"

keyser · **Joined:** Sun Dec 19, 2010 4:49 am **Posts:** 1

We want to do some query like this:

We have a subquery which generate a set:

Code:

SELECT s.id FROM Something s WHERE s.xxx = 1

The result is a big set. And we want to know if a specific object is in this set. before we start using hibernate, we have written this:

Code:

SELECT 150 IN (SELECT id FROM something WHERE xxx = 1)

150 is the id we want to test whether it is in the set.

We try something like that:

Code:

SELECT 150 IN (s.id FROM Something s WHERE s.xxx = 1)

but it's not work.

Please help.

chirag.naikec · **Posted:** Mon Dec 20, 2010 4:20 am

It should be something like this,

Code:

select column_name from table_name where 150 in (SELECT s.id FROM Something s WHERE s.xxx = 1)

Maybe this can help you.