Answer Posted / Rahul Bhardwaj
A subquery is a type of SQL query that is nested within another SQL statement. It retrieves data from a database based on the results of another SQL query. Subqueries can be used for various purposes, such as filtering data, performing calculations, and joining tables. The outer query retrieves data based on the results returned by the inner query. There are several types of subqueries in SQL: simple subquery, correlated subquery, existential subquery, and common table expression (CTE).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are all the common sql function? : Sql dba
define sql insert statement ? : Sql dba
what are aggregate and scalar functions? : Sql dba
What is your daily office routine?
how to use regular expression in pattern match conditions? : Sql dba
How do I remove duplicates in two columns?
how many tables will create when we create table, what are they? : Sql dba
Is primary key clustered index?
Is primary key always clustered index?
What is the current version of sql?
how to escape special characters in sql statements? : Sql dba
what is collation? : Sql dba
Can we rollback truncate?
Can we use distinct and group by together?
