SQL query in SQLite / DB browser returning no values

Question

I can't seem to get a basic SQL query to work in SQLite. It's just a single 8 column table in db-browser for sqlite. Some of the data-types aren't correct here, but it shouldn't impact end results

I'm getting no results returned, it should be 116 results.

Data represented in SQLite

Basic SQL statement

select
    `CountyName`,
    gender,
    sum(population)
from secondTable
where Year = 2014
group by `CountyName`, gender
order by `CountyName`, gender

TheMouseMaster · Accepted Answer · 2019-01-23 22:05:59Z

2

It appears your "year" column is defined as type "TEXT".

If the rows where year is 2014 are actually "2014.0" (like all of the 2010 examples your picture shows), then the WHERE clause isn't going to match on them.

answered Jan 23, 2019 at 22:05

TheMouseMaster

2981 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gauravsa · Accepted Answer · 2019-01-23 22:10:17Z

1

Sqllite doesnt have a datetime type, so for comparison you have to so this:

select
    `CountyName`,
    gender,
    sum(population)
from secondTable
where Year = “2014”
group by `CountyName`, gender
order by `CountyName`, gender

If you have an actual date, there are functions like strftime

answered Jan 23, 2019 at 22:10

Gauravsa

6,6382 gold badges25 silver badges33 bronze badges

Collectives™ on Stack Overflow

SQL query in SQLite / DB browser returning no values

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related