Query logic [message #337870] |
Fri, 01 August 2008 07:37  |
gauravpuri2002
Messages: 24 Registered: October 2007 Location: Bangalore
|
Junior Member |
|
|
Hi
In my table there is one column and has values 2,3,7
Now i want to write a query that will display those values which are less than 10 and don't contain 2,3 and 7.that is it will display 1,4,5,6,8,9,10
Regards
Gaurav
|
|
|
Re: Query logic [message #337874 is a reply to message #337870] |
Fri, 01 August 2008 07:46   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
10 is not less than 10 where I come from.
where whatever < 10
and whatever not in (2,3,7);
As basic as a where clause can be.
[edit]
Ok, upon further reading, it looks like another example of unclear description of the problem, but have a look at connect by clause, if my assumption is correct.
[Updated on: Fri, 01 August 2008 07:48] Report message to a moderator
|
|
|
|
|