Hi,

 

i need to know what is difference in meaning of collate between this three queries

FIRST and SECOND is accepted by server

but THIRD return error "Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause)"

 

/* FIRST */

select w.wplata_nr_wyciagu collate PXW_PLK

FROM

WPLATA w

group by w.wplata_nr_wyciagu

order by w.wplata_nr_wyciagu

 

 

 

/* SECOND */

select w.wplata_nr_wyciagu collate PXW_PLK

FROM

WPLATA w

group by w.wplata_nr_wyciagu collate PXW_PLK

order by w.wplata_nr_wyciagu collate PXW_PLK

 

 

/* THIRD */

select w.wplata_nr_wyciagu

FROM

WPLATA w

group by w.wplata_nr_wyciagu collate PXW_PLK

order by w.wplata_nr_wyciagu collate PXW_PLK

 

 

regards,

Karol Bieniaszewski