Reputation: 721
This is the table
chr
chr1
chr2
chr10
chrU_X
chrM_a_a
I want to get only chr%andnumber% (chr1, chr2,chr10 this case) with:
select chr
from varianti
where chr like 'chr_'
group by chr
But it returns only chr1 , chr2 not chr10.
I want to get the result like this:
chr
chr1
chr2
chr10
Is there somethings wrong?
Upvotes: 3
Views: 45