what is the difference between the query and corelated
query
Answer Posted / saurabh
When 1st main query is executed then the result of the main
query is used in teh where clause of subquery then this
type of subquery is called as co-related sub query.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the subsets of sql?
What is the use of sqlerrd 3?
how to create a new view in mysql? : Sql dba
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is sql query limit?
What is a sql*loader control file?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
Define the select into statement.
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is the sql case statement?
What is integrity in sql?
What is replication id?
Explain the difference between triggers and constraints?
What does the sign mean in sql?
What is a file delimiter?