heyanger / sqltools

3 stars 0 forks source link

Support for distinct #18

Open heyanger opened 5 years ago

heyanger commented 5 years ago

1) sql1=select carrier from device sql2=select count (distinct carrier) from device wrong=select from device

2) sql1=select country from singer where age > 20 sql2=select distinct country from singer where age > 20 wrong=select distinct country, country from singer where age > 20