Interested to Buy Any Domain ? << Click Here >> for more details...
What is a sub-query? When would you use one?
- 3 Answers
- 14404 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 are the steps to process a single select statement?
How to add an address record into adventureworkslt?
How to bind a view to the schema of the underlying tables?
Why should we go for stored procedures? Why not direct queries?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
How to truncate a table first before running a package?
Do you know the cursor types?
what are default? Is there a column to which a default cant be bound?
What is 2nf example?
Explain full-text indexing?
select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
-
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)
