# Data from not showing from select **URL:** \ **Category:** Systems\ **Tags:** influxql\ **Created:** [July 27, 2017, 6:19pm UTC](https://community.influxdata.com/t/data-from-not-showing-from-select/1786 "2017-07-27T18:19:05Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![jmls](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@jmls](https://community.influxdata.com/u/jmls)\ **Post date:** [July 27, 2017, 6:19pm UTC](https://community.influxdata.com/t/data-from-not-showing-from-select/1786/1 "2017-07-27T18:19:05Z")
Good evening all - I am trying to get some top xx data out of influx, and being both a influx and sqlish newbie I am struggling to understand what I am doing wrong If have this query `SELECT sum(value) as total FROM issue GROUP BY user` where `value` is a field that is 1 , and `user` is a tag this _does_ give me the data I want : a list of all the users with the total number of issues so, now I want a β€œtop 10”, and change the query to this `SELECT top(total,10), user from (SELECT sum(value) as total FROM issue GROUP BY user)` I do indeed get the top 10 records, but the `user` column is blank what am I missing ? thanks ---
**Author:** ![jmls](https://avatars.discourse-cdn.com/v4/letter/j/b2d939/32.png) [@jmls](https://community.influxdata.com/u/jmls)\ **Post date:** [July 29, 2017, 2:37pm UTC](https://community.influxdata.com/t/data-from-not-showing-from-select/1786/2 "2017-07-29T14:37:20Z")
no takers ? I really would like to know what I am doing wrong , as I think I have done everything right πŸ™‚ ---
**Author:** ![sbains](https://avatars.discourse-cdn.com/v4/letter/s/cdc98d/32.png) [@sbains](https://community.influxdata.com/u/sbains)\ **Post date:** [August 2, 2017, 6:58pm UTC](https://community.influxdata.com/t/data-from-not-showing-from-select/1786/3 "2017-08-02T18:58:33Z")
Try grouping it by user under top query like this SELECT top(total,10) from (SELECT sum(value) as total FROM issue GROUP BY user) GROUP BY user