SELECT count(distinct c) as nb FROM t_asv where b = 1 group by b
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
1 And God blessed Noah and his sons, and said unto them, Be fruitful, and multiply, and replenish the earth. 2 And the fear of you and the dread of you shall be upon every beast of the earth, and upon every bird of the heavens; With all wherewith the ground teemeth, and all the fishes of the sea, into your hand are they delivered. 3 Every moving thing that liveth shall be food for you; As the green herb have I given you all. 4 But flesh with the life thereof, `which is' the blood thereof, shall ye not eat. 5 And surely your blood, `the blood' of your lives, will I require; At the hand of every beast will I require it. And at the hand of man, even at the hand of every man's brother, will I require the life of man. 6 Whoso sheddeth man's blood, by man shall his blood be shed: For in the image of God made he man. 7 And you, be ye fruitful, and multiply; Bring forth abundantly in the earth, and multiply therein. 8 And God spake unto Noah, and to his sons with him, saying, 9 And I, behold, I establish my covenant with you, and with your seed after you; 10 and with every living creature that is with you, the birds, the cattle, and every beast of the earth with you. Of all that go out of the ark, even every beast of the earth. 11 And I will establish my covenant with you; neither shall all flesh be cut off any more by the waters of the flood; neither shall there any more be a flood to destroy the earth. 12 And God said, This is the token of the covenant which I make between me and you and every living creature that is with you, for perpetual generations: 13 I do set my bow in the cloud, and it shall be for a token of a covenant between me and the earth. 14 And it shall come to pass, when I bring a cloud over the earth, that the bow shall be seen in the cloud, 15 and I will remember my covenant, which is between me and you and every living creature of all flesh; and the waters shall no more become a flood to destroy all flesh. 16 And the bow shall be in the cloud; and I will look upon it, that I may remember the everlasting covenant between God and every living creature of all flesh that is upon the earth. 17 And God said unto Noah, This is the token of the covenant which I have established between me and all flesh that is upon the earth. 18 And the sons of Noah, that went forth from the ark, were Shem, and Ham, and Japheth: and Ham is the father of Canaan. 19 These three were the sons of Noah: and of these was the whole earth overspread. 20 And Noah began to be a husbandman, and planted a vineyard: 21 and he drank of the wine, and was drunken. And he was uncovered within his tent. 22 And Ham, the father of Canaan, saw the nakedness of his father, and told his two brethren without. 23 And Shem and Japheth took a garment, and laid it upon both their shoulders, and went backward, and covered the nakedness of their father. And their faces were backward, and they saw not their father's nakedness. 24 And Noah awoke from his wine, and knew what his youngest son had done unto him. 25 And he said, Cursed be Canaan; A servant of servants shall he be unto his brethren. 26 And he said, Blessed be Jehovah, the God of Shem; And let Canaan be his servant. 27 God enlarge Japheth, And let him dwell in the tents of Shem; And let Canaan be his servant. 28 And Noah lived after the flood three hundred and fifty years. 29 And all the days of Noah were nine hundred and fifty years: And he died.