08-25-03, 14:41
|
|
Registered User
|
|
Join Date: Jan 2003
Posts: 3,574
|
|
Anto,
SELECT app_id from mytable where seq_id = 1;
Andy
Quote:
Originally posted by antodomnic
Ok, I think still I am not clearly explained.
I have a table , with app_id, seq_id,seq_data.
It has values like the bellow
--------------------------------
One Record
---------------
app_id , seq_id , seq_data
21 , 1 , some_data ....
21 , 2 , some_data1...
21 , 3 , some_data2...
Second Record
-------------------
app_id , seq_id , seq_data
22 , 1 , second_data....
Third Record
----------------
app_id , seq_id , seq_data
23 , 1 , third_data....
23 , 2 , third_data1...
Now I need to exclue the app_id which has greater than 1 ie 2, 3 etc.. I need to extract app_id's which has seq_id only "1". What's the sql query i need to execute.
Thanks
|
|
|