# Sqlite select query not returning data

**URL:** https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742
**Category:** General
**Created:** [15 October 2019 18:44 UTC](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742 "2019-10-15T18:44:22Z")
**Posts on this page:** 1
**Showing post:** 10

<div class="post-metadata">

### Author: ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)
#### Post date: [18 October 2019 10:39 UTC](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742/10 "2019-10-18T10:39:45Z")

</div>

Well you're going to kick yourself. Try removing the first line (the create index) and see what you get.

---

_[View the full topic](https://discourse.nodered.org/t/sqlite-select-query-not-returning-data/16742)._