Thread: Db2 Sql Query
View Single Post
  #1 (permalink)  
Old 08-25-03, 13:30
antodomnic antodomnic is offline
Registered User
 
Join Date: Mar 2003
Posts: 69
Db2 Sql Query

Looks like a silly question.
But how do I execute this,

I have a table in which I have a field called seq_i which can contain values greater than 1.
I need to execute a sql query which can extract all the values which are equal to 1 and not greater than 1 ( remember I can store any number from 1 to n ( n stands for any)).
Also I don't want to use sub queries, worst case I can go. But Is there a way I can extract directly.


Thanks.
Anto. A.R.
Reply With Quote