The SQL query can be run against our DocumentDB database in Azure portal that has a Query Explorer.
The Query Explorer is used to demonstrate the many different capabilities and features of the query language starting with the simplest possible query.
Step 1 : Azure Portal is opened, and in the database blade, click the Query Explorer blade.
As the queries are run within the scope of a collection, the Query Explorer lets us choose the collection in this dropdown. The set to Families collection that contains the three documents. These three documents are shown in this example.
The below code is an AndersenFamily document.
The below code is the SmithFamily document.
The below code is the WakefieldFamily document.
The query SELECT * FROM c is used to open the Query Explorer. That retrieves all documents from the collection. But it's still quite different than the equivalent query in a relational database.
Step 2 :
Step 3 : Click ‘Run’ to execute query and open the Results blade.
From the above figure you can see that, the WakefieldFamily, the SmithFamily, and the AndersonFamily are retrieved.
The three documents which are retrieved as a result of the SELECT * FROM c query is shown below.
In the above result the system-generated properties are included which are prefixed with the underscore character.
DocumentDB SQL Related Interview Questions
|DB2 Using SQL Interview Questions||Dbase Interview Questions|
|DB2 SQL Programming Interview Questions||Document Type Definition (DTD) Interview Questions|
|CouchDB Interview Questions||DB 400 Interview Questions|
|Documentum Interview Questions|
Documentdb Sql Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.