Gacha Posted April 8, 2004 Report Share Posted April 8, 2004 Nu ir vienā laukā daudz ierakstu kādi 100, bet 40 no viņiem ir "BLABLA" 30 ir "BUBU" un parejie 30 ir "LALA". Kā es varu no DB dabūt arā tikai 1 ierakstu no katra veida? Link to comment Share on other sites More sharing options...
Aleksejs Posted April 8, 2004 Report Share Posted April 8, 2004 select distinct Link to comment Share on other sites More sharing options...
hu_ha Posted April 8, 2004 Report Share Posted April 8, 2004 select * from tabula group by kolona kur "kolona" ir tas lauks, kas satur tavu lala, blabla, etc Link to comment Share on other sites More sharing options...
Gacha Posted April 8, 2004 Author Report Share Posted April 8, 2004 Es jau domaju, ka kaut kur man tas distinc un group by būs jaizmanto, jo šāmie bieži redzēti, bet nebija lietoti. B) Link to comment Share on other sites More sharing options...
bubu Posted April 9, 2004 Report Share Posted April 9, 2004 kaa var vienaa laukaa buut 100 ieraksti? Link to comment Share on other sites More sharing options...
Gacha Posted April 9, 2004 Author Report Share Posted April 9, 2004 Pienjemsim lauks "diena" un tur ir: 1diena 1diena 1diena 1diena 1diena 1diena 2diena 2diena 2diena 2diena 2diena 2diena 5diena 5diena 5diena 5diena 5diena 5diena Link to comment Share on other sites More sharing options...
Recommended Posts