+ 1
what is query? is there any basic explanation for queries and sub queries?
6 odpowiedzi
+ 4
A query is simply a statement you execute on a database. A sub-query is a nested query.
+ 2
Query is like a question on the database
+ 2
Query is a command for the Database to do something. Subquery is a query within another query embedded within the WHERE clause.
0
In easy terms Query is just like enquiring the database
0
A query is a statement which u give and the subqueries are queries inside the query.
0
A good example of query might be
Select * From [Table_Name]
And a query with a subquery might be
Select * From [Table_Name] => query
Where [Column_Name or condition u wanna apply] IN (Select [column_Name] From [Table_Name] and a Where statement if you wanna apply any condition) => Subquery
The subquery is between the comma i know sometimes as programmer is better to see the code than the meaning to have a better understanding. Hope its help u out