What is the query and subquery?

Sharad Jaiswal
Sharad Jaiswal

Posted On: Feb 22, 2018

 

A query is basically a request for the database or the information associated with it in the combination of tables. A query associated with the database can either be a select or an action query.

A SQL query with the other significant query is called a subquery. We can also say it as a subset of all selected states where the values are used for the filtering the results of the main query.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...