搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

A subquery can be used to （）.

A、Create groups of data

B、Sort data in a specific order

C、Convert data to a different format

D、Retrieve data based on an unknown condition

查看正确答案
更多“A subquery can be used to （）.”相关的问题
第1题
[多选题] Which three statements about subqueries are true? （）

A、A main query can have more than one subquery.  B、A subquery can have more than one main query.  C、The subquery and main query must retrieve data from the same table.  D、The subquery and main query can retrieve data from different tables.  E、Only one column or expression can be compared between the subquery and main query.  F、Multiple columns or expression can be compared between the subquery and main query.  

点击查看答案
第2题
[] Which three statements about subqueries are true? （）

A、A. A main query can have more than one subquery.  B、B. A subquery can have more than one main query.  C、C. The subquery and main query must retrieve data from the same table.  D、D. The subquery and main query can retrieve data from different tables.  E、E. Only one column or expression can be compared between the subquery and main query.  F、F. Multiple columns or expression can be compared between the subquery and main query.  

点击查看答案
第3题
[多选题] Which three statements about subqueries are true? （）

A、A single row subquery can retrieve only one column and one row.  B、A single row subquery can retrieve only one row but many columns.  C、A multiple row subquery can retrieve multiple rows and multiple columns.  D、A multiple row subquery can be compared using the ">" operator.  E、A single row subquery can use the IN operator.  F、A multiple row subquery can use the "=" operator.  

点击查看答案
第4题
[多选题] Which three statements about subqueries are true?（）

A、A single row subquery can retrieve only one column and one row.  B、A single row subquery can retrieve only one row but many columns.  C、A multiple row subquery can retrieve multiple rows and multiple columns.  D、A multiple row subquery can be compared by using the ">" operator.  E、A single row subquery can use the IN operator.  F、A multiple row subquery can use the "=" operator.  

点击查看答案
第5题
[] Which three statements about subqueries are true?（）

A、A. A single row subquery can retrieve only one column and one row.  B、B. A single row subquery can retrieve only one row but many columns.  C、C. A multiple row subquery can retrieve multiple rows and multiple columns.  D、D. A multiple row subquery can be compared by using the ">" operator.  E、E. A single row subquery can use the IN operator.  F、F. A multiple row subquery can use the "=" operator.  

点击查看答案
第6题
[] Which three statements about subqueries are true?（）

A、A. A single row subquery can retrieve only one column and one row.  B、B. A single row subquery can retrieve only one row but many columns.  C、C. A multiple row subquery can retrieve multiple rows and multiple columns.  D、D. A multiple row subquery can be compared by using the “>” operator.  E、E. A single row subquery can use the IN operator.  F、F. A multiple row subquery can use the “=” operator.  

点击查看答案
第7题
[多选题] Which two statements about subqueries are true? （）

A、A subquery should retrieve only one row.  B、A subquery can retrieve zero or more rows.  C、A subquery can be used only in SQL query statements.  D、Subqueries CANNOT be nested by more than two levels.  E、A subquery CANNOT be used in an SQL query statement that uses group functions.  F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.  

点击查看答案
第8题
[多选题] Which two statements about subqueries are true? （）

A、A subquery should retrieve only one row.  B、A subquery can retrieve zero or more rows.  C、A subquery can be used only in SQL query statements.  D、Subqueries CANNOT be nested by more than two levels.  E、A subquery CANNOT be used in an SQL query statement that uses group functions.  F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.  

点击查看答案
第9题
[多选题] Which two statements about subqueries are true? （）

A、A subquery should retrieve only one row.  B、A subquery can retrieve zero or more rows.  C、A subquery can be used only in SQL query statements.  D、Subqueries CANNOT be nested by more than two levels.  E、A subquery CANNOT be used in an SQL query statement that uses group functions.  F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.  

点击查看答案
第10题
[多选题] Which two statements are true regarding subqueries? （）

A、A subquery can retrieve zero or more rows   B、Only two subqueries can be placed atone level   C、A subquery can be used only in SQL query statements   D、A subquery can appear on either side of a comparison operator   E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement   

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服