Interested to Buy Any Domain ? << Click Here >> for more details...
What is a sub-query? When would you use one?
- 3 Answers
- 14227 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mkd
A subquery is a SELECT statement that is nested within
another T-SQL statement. A subquery SELECT statement if
executed independently of the T-SQL statement, in which it
is nested, will return a result set. Meaning a subquery
SELECT statement can standalone and is not depended on the
statement in which it is nested.
Sometimes the criteria for determining which set of records
will be affected by a SELECT, UPDATE, DELETE and/or INSERT
statement cannot be obtained by hard coding the selection
criteria. Occasionally there is a need to use the results
of a SELECT statement to help determine which records are
returned or are affected by a T-SQL statement. When a
SELECT statement is used inside another statement, the
inside SELECT statement is known as a subquery.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / c suresh kumar
sub query is part of main query.this useful we retrive data
from the another table.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / swapna
Subquery is used to get information from a table based on
unknown conditions.
If select stmt not perform entire task using
selection,projection,and joins then we can perform that
type of task using sub queries.
| Is This Answer Correct ? | 3 Yes | 8 No |
What is database architecture? : SQL Server Architecture
How do I partition a table in sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
How to delete duplicate rows from table except one?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
What types of integrity are enforced by a foreign-key constraint
What are system databases in ms sql server?
What are the pre-defined functions in the sql server?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Write a code to select distinct records without using the DISTINCT keyword.
What is the difference between value type and reference type?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
