What are sub-queries? Give example? In which case
sub-queries are not feasible?
Answers were Sorted based on User's Feedback
Answer / bernatshaw
Sub-query means a Query within a Query.
This is the Example:
Select Employee_Id, Employee_name From Employees Where
Employee_Id IN (Select Mgr_Id from Manager)
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / rajendra
Sub query mean query within query ,but when you use sub
query on larg amount data that time it is not feasible
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / 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 |
Answer / amit kumar
A subquery is simply a SELECT query within a SELECT query.
example:-
SELECT City, Salary, (SELECT AVG(Salary) FROM Employee)
AS AvgSalary FROM Employee;
Is This Answer Correct ? | 1 Yes | 4 No |
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
what is a stored procedure and trigger?
When do we use the UPDATE_STATISTICS command?
4 Answers Deutsche Telekom AG,
What happens to a statement batch if there is a compilation error?
How do you create an execution plan?
what do you understand by change data capture?
Tell me about the approaches which you used to counter the DI problems.
what is mean by crystal repoart? ahere we will mainly use that?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is candidate key with example?
What is change data capture (cdc) feature?
What is the most common trace flags used with sql server?