Runs first,executed once,returns values to be used by the MAIN Query

What is the Subquery?

Question Posted / anil_abbireddy

Answer Posted / anil_abbireddy

Runs first,executed once,returns values to be used by the
MAIN Query

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which is faster subquery or join?

1217

What is multiple columns?

1066

Why is theta join required?

1145

What is difference between rank () row_number () and dense_rank () in sql?

1101

What are the two types of periodical indexes?

940

What are sql indexes?

999

What is the difference between count 1 and count (*) in a sql query?

993

what is a view? : Sql dba

1092

What are basic techniques of indexing?

1384

what is the syntax used for partition in tsql? : Transact sql

1014

Does google use sql?

959

how many ways to get the current time? : Sql dba

1007

What are the uses of merge?

1167

What are the advantages of pl sql over sql?

1025

What is having clause in sql?

963