Re: complex duplicate row


adrian.baceanu@xxxxxxxxx said:
>
> But how to select duplicate rows (identical in all the columns, except
> codfisc) and in the same time the result also to include this column,
> codfisc?

SELECT * FROM f103;

--
Bye now,
Obnoxio

"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule"
- Coluche

did i mention i like nulls? heck, i even go so far as to say that all
columns in a table except the primary key could/should be nullable. this
has certain advantages, for example, if you need to insert a child record
and you don't have a parent row for it, just do an insert into the parent
table with the primary key value (everything else null), and voila,
relational integrity is preserved. but this is, admittedly, a bit
controversial among modellers.

--r937, dbforums.com
sending to informix-list
.

Relevant Pages

  • Re: Primary key with or without?
    ... Temporary tables or working tables could be one situation where the creation ... does say that having a primary key is not required in the Ansi SQL Standard! ... John ... > loads from data files with duplicate rows? ...
    (microsoft.public.sqlserver.programming)
  • Re: Removing duplicate records
    ... > Thank you for posting in the community! ... > Xml files into one and you need to remove the duplicate rows. ... The primary key is for the table to identify a row and ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Removing duplicate records
    ... I would like to confirm my understanding of your issue. ... Xml files into one and you need to remove the duplicate rows. ... The primary key is for the table to identify a row and to ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: complex duplicate row
    ... > But how to select duplicate rows (identical in all the columns, ... > codfisc) and in the same time the result also to include this column, ... SELECT INDISTINCT ... ... Prev by Date: ...
    (comp.databases.informix)
  • Re: complex duplicate row
    ... > But how to select duplicate rows (identical in all the columns, ... > codfisc) and in the same time the result also to include this column, ... Karl ... Prev by Date: ...
    (comp.databases.informix)