sql help pls

[mayamanako]

hi can u help me pls to write the sql statement. ive got a table:

id | field2 | field3
1 | 1 | 0
2 | 1 | 0
3 | 1 | 0
4 | 4 | 0
5 | 5 | 1

i would like to get a result as:

3 | 1 | 0
4 | 4 | 0

im using this in some kinda versioning feature. im stuck. dont know where to start the sql statement for this. im using asp. thnks for ur help.

 

[onpnt]

ASP has little to do with your problem other than methods of troubleshooting syntax "after" you write your valid SQL statements (aside not knowing the language you are using (DB))

Find the SQL forum that matches your DB and thus SQL construct and post this question there please


General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[gmmastros]

This is a duplicate posting. thread183-1237362

I agree with onpnt, this is a SQL issue. I have answered the question in that thread.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mayamanako]

my apologies guys.