querying – IT Nursery

Is there a query language for JSON?

May 23, 2022 by IT Nursery

Is there a (roughly) SQL or XQuery-like language for querying JSON? I’m thinking of very small datasets that map nicely to JSON where it would be nice to easily answer queries such as “what are all the values of X where Y > 3” or to do the usual SUM / COUNT type operations. As … Read more

Nested select statement in SQL Server

May 5, 2022 by IT Nursery

Why doesn’t the following work? SELECT name FROM (SELECT name FROM agentinformation) I guess my understanding of SQL is wrong, because I would have thought this would return the same thing as SELECT name FROM agentinformation Doesn’t the inner select statement create a result set which the outer SELECT statement then queries? 2 Answers 2