The following sql statement contains what type of subqueries? select isbn, title from books where pubid = (select pubid from books where title = 'shortest poems') and retail-cost > (select avg(retail-cost) from books);



Nested SQL Subquery

Explanation:

There are three types of SQL subquery

inline view, Nested Subquery and Scalar Subquery

The Nested SQL Subqueries are queries that appears in the WHERE clause of the SQL statement, as appeared in the above question.

A subquery can be nested inside other subqueries and that is one of the abilities of SQL.

Once this query is placed in the WHERE clause, then it's called a Nested SQL subquery

answer; insolated i/o uses separate memory space,and on the other hand memory mapped i/o uses memory from the main

to change your username, you must:

1) make sure what the username you want to change to is allowed in this community

2) contact a administrator (for example, jaysl)

3) through pm, tell the admin what you want to change to

4) if the username is allowed, it will be changed in a matter of seconds (minutes at most)

~