a query return with some identical rows,
how can I distinguish them?

what I want is like this:

select rowid, column1, column2 from mytable

TIA

"chenhong"  wrote in message 
news:eQYwbbY3HHA.3900@TK2MSFTNGP02.phx.gbl...


>a query return with some identical rows,
> how can I distinguish them?
>
> what I want is like this:
>
> select rowid, column1, column2 from mytable
>
> TIA


select DISTINCT rowid, column1, column2 from mytable


-- 
Mark Rae
ASP.NET MVP
http://www.markrae.net

Hi,
if you would like to distinguish between two identical rows you have to 
change your query to use some row numbering. SQL 2005 provides you mechanism 
to do that:

select 
  NumberedTable.*
from
(
  select 
    column1, column2, 
    ROW_NUMBER() over (order by column1, column2) as RowNum
  from myTable
) NumberedTable

If you do not use SQL 2005 you have to create temporary table with one more 
identity column and first fill this table with your date and after that 
select that data from this table.

There is still question if your identical rows will always be in same order 
but who knows? :)

Regards,
Ladislav

"chenhong" wrote:


> a query return with some identical rows,
> how can I distinguish them?
> 
> what I want is like this:
> 
> select rowid, column1, column2 from mytable
> 
> TIA
>