.......... are complete select-from-where blocks with in another SQL query.
.......... किसी अन्य SQL क्वेरी के भीतर कम्प्लीट सेलेक्ट-फ्रॉम-वेयर ब्लॉक हैं।
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: A. Nested queries
Explanation
A nested query (subquery) is a full SELECT-FROM-WHERE block placed inside another query, e.g. in the WHERE clause: ... WHERE salary > (SELECT AVG(salary) FROM emp).
नेस्टेड क्वेरी (सबक्वेरी) किसी दूसरी क्वेरी के अंदर रखा गया पूरा SELECT-FROM-WHERE ब्लॉक है, जैसे WHERE salary > (SELECT AVG(salary) FROM emp)।
More Database Management & SQL questions
- The select operation is used to choose a subset of tuples from a relation that satisfies a .............. .
- To get information from users you use ........... .
- This command is used to modify attribute values of one or more selected tuples :
- Degree of relationship type is the number of participating .............. .
- The query that is used to summarize the data from various tables is called as :
- In database ........... type of field is used to insert various objects mode in other Windows applications into table.