Skip to main content Link Menu Expand (external link) Document Search Copy Copied

SELECT FROM ndjson-target

The following SELECT statements demonstrate

Before you begin

SELECT with WHERE, LIKE, ORDER BY clauses 

SELECT _id, actor_id, repo_url
  FROM ndjson-target
  WHERE repo_url LIKE '%suneg%'
  ORDER BY actor_id;

   _id     | actor_id | repo_url
-----------+--------- +----------------------------------------------
2489677800 | 1258383  | https://api.github.com/repos/suneg/dojo_rules
2489673246 | 1258383  | https://api.github.com/repos/suneg/dojo_rules
2489651106 | 1258383  | https://api.github.com/repos/suneg/dojo_rules
2489651097 | 1258383  | https://api.github.com/repos/suneg/dojo_rules

Further information