What are sub-queries? Give example? In which case
sub-queries are not feasible?
- 4 Answers
- 12233 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / akhil
text and image datatypes are not allowed in
subqueries.Subqueries cannot manipulate their results
internally, that is, a subquery cannot include the order by
clause, the compute clause, or the into keyword.
Correlated (repeating) subqueries are not allowed in the
select clause of an updatable cursor defined by declare cursor.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is acid mean in sql server?
How to remove duplicate rows from table except one?
When should you use an instead of trigger?
What are the different types of subquery?
Equi join and non equi join is possible with sql server?
What are the source of constraints?
do you know how to configure db2 side of the application? : Sql server database administration
How do I find the sql server version?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is sql or structured query language?
What is a coalesce function?
Can we shrink data file in sql server?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How to convert numeric expression data types using the cast() function?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
