Top "Querying" questions

Nested select statement in SQL Server

Why doesn't the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, …

sql sql-server nested subquery querying
Is there a query language for JSON?

Is there a (roughly) SQL or XQuery-like language for querying JSON? I'm thinking of very small datasets that map nicely …

json nosql web-standards querying dynamic-queries
PHP and MySQL: Order by most recent date and limit 10

I am building a notes system on my site and I've got to the stage where users can post notes …

php mysql sql-order-by limit querying
Query a single document from Firestore in Flutter (cloud_firestore Plugin)

I want to retrieve data of only a single document via its ID. My approach with example data of: TESTID1 { …

firebase dart flutter google-cloud-firestore querying
MongoDB/PyMongo: Querying multiple criteria - unexpected results

I have a collection where some of the objects feature an key foo. I now try to query for all …

python mongodb pymongo querying
Querying JSON with JSONPath or SelectTokens? With JSON.NET in C#

I am trying to use the Newtonsoft.Json.Net in c#. The following is part of JSON file that I …

json json.net querying
Querying array elements with Mongo

How can I query the smoothies that have apple in them? (below is a collection with 3 documents) _id => 1 name =&…

mongodb querying odm
MongoDB query check if value in array property

I cannot find out of how to check, if some value are in array property in mongo document. For example, …

mongodb querying
How to properly query a Firebase list in AngularFire2?

I'm developing an Angular2 application with Firebase as a backend. On a subpage I want to display some tasks for …

firebase firebase-realtime-database observable angularfire2 querying
MongoDB: how to find documents ignoring case sensitive, accents and percent like logic (%)

I would like to make a search on a collection in my mongodb database. In my collection, I have documents …

mongodb mongoose mongodb-query case-insensitive querying