Select only newest inputs from a table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

Select only newest inputs from a table

Author

Topic

Nosediver
Starting Member

7 Posts

Posted - 2007-10-17 : 05:19:01

Hello,
I am still busy with my database and running into new problems.

Now it is the following.

I have one table like

A ID | B Characteristic 1 | C Char. 2 | D Char. 3 | E Char. 4. | F Update | G Result
1 | xx | zz | zz |qq |mm/dd/yyyy | good
2 | xx | zz | zz |qq |mm+1/dd/yyyy | bad
3 | xx | zz | xz |qq |mm/dd/yyyy | bad
4 | xx | zz | kl |qq |mm/dd/yyyy | bad

...
Now I want to run a query on it and get as result only ID 2,3,4 because 2 and 3 are distinct from each other in column B or C or D or E. I Dont want to get as a result number 1 because it is outdated.

I really appreciate it if you can help me on this also

Lars

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2007-10-19 : 18:08:28

Result <> 'good'
or
Result = 'bad'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources