SQL Server Subqueries interview questions
A subquery is a query
within a query. These sub queries are created with SQL
statements....................
Read
answer
Sub Query Example with IN:
Displays employees from employee table with bonus > 1000. Using
IN first all employees are selected and compared to each row of the
subquery..............
Read
answer
Comparison operators can
be used (like <, >, =, !> etc). Sub queries used with
comparison operators must return a single value rather than a list
to avoid error. Hence the nature of the database must be knows
before executing such sub queries................
Read
answer
A subquery with Exist does
not really return any data; it returns TRUE or FALSE. Example: This
select statement will return all records from the sales table where
there is at least one record in the orders table with the same sales
_id................
Read
answer
<<Previous
Next>>
Also read
SQL EXISTS: If the subquery returns at least one row the EXISTS
condition is considered "to be met"...............
SQL MINUS returns all rows in the first query that are not
returned in the second query..................
Answer - The start and end of each
transaction......
Answer - A database is a structured collection of data. Database can
be thought as simple data file......
Answer - SQL Server English Query helps to build
applications that can accept query.....
Answer - SQL Server uses the following steps to
process a single SELECT statement....
Answer - Null means no entry has been made. It implies that the
value is either unknown or undefined.....
|
