You are here: Re: SQL Statement to return first unique record « MsSQL Server « IT news, forums, messages
Re: SQL Statement to return first unique record

Posted by Ed Murphy on 01/19/07 13:45

jim wrote:

> I've been searching and trying out SQL statements for hours and I'm
> still having a problem.
>
> I'm querying 3 tables... and I only want the first unique record
> returned.

You need to clearly define "unique" and "first". Based on your
example, it looks like you mean "unique combination of values from
the first two columns" and "lowest value from the third column".

> Currently, the data returned looks like this..............
>
> New York New York A
> New York New York B
> New York New York C
> Los Angeles California A
> Los Angeles California B
> Los Angeles California C
>
>
> I want the select statement to return this instead...
>
> New York New York A
> Los Angeles California A

select c1, c2, min(c3)
from t1
group by c1, c2

You'll need to adjust this to account for three tables instead of
one, but hopefully you get the idea.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация