KillerBean Posted August 22, 2006 Report Share Posted August 22, 2006 gribeeju uzzinaat, kaa var noraadiit ORDER BY grupu (vispirms peec a kolonas, peec tam ja a vienaada, tad b kolonu, utt.) un 2. - kaa var likt nolasiit tikai 1x veertiibu, ja taa atkaartojas tabulaa kaut vai 5x. Link to comment Share on other sites More sharing options...
Roze Posted August 22, 2006 Report Share Posted August 22, 2006 1. ORDER BY a, b, c .... 2. GROUP BY a Link to comment Share on other sites More sharing options...
KillerBean Posted August 22, 2006 Author Report Share Posted August 22, 2006 tnx. buus jaapaluur. Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 22, 2006 Report Share Posted August 22, 2006 kaa var likt nolasiit tikai 1x veertiibu, ja taa atkaartojas tabulaa kaut vai 5x. DISTINCT SELECT DISTINCT c1, c2, c3 FROM t1 WHERE Link to comment Share on other sites More sharing options...
goldy Posted August 22, 2006 Report Share Posted August 22, 2006 ar DISTINCT atlasīsies unikālas rindas C1 C2 C3 a 1 2 a 2 3 a 2 2 bet ja vajag vienu unikālu vērtību, tad GROUP BY Link to comment Share on other sites More sharing options...
Grey_Wolf Posted August 22, 2006 Report Share Posted August 22, 2006 goldy --> tieshi Taads arii bija jautaajums :) // kaa var likt nolasiit tikai 1x veertiibu, ja taa atkaartojas tabulaa kaut vai 5x. // Link to comment Share on other sites More sharing options...
Recommended Posts