Anto,
Try:
SELECT * from ... where seq_i = 1
Andy
Quote:
Originally posted by antodomnic
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.
|