查询顾客地址以“江苏省XX市”开头的信息,其中市名为两个字,如“南京、苏州”等,使用的SQL语句为:()
A.select * from 顾客 where 地址 like ‘江苏省%市%’
B.select * from 顾客 where 地址 = ‘江苏省%市%’
C.select * from 顾客 where 地址 like ‘江苏省__市%’
D.select * from 顾客 where 地址 = ‘江苏省__市%’
A.select * from 顾客 where 地址 like ‘江苏省%市%’
B.select * from 顾客 where 地址 = ‘江苏省%市%’
C.select * from 顾客 where 地址 like ‘江苏省__市%’
D.select * from 顾客 where 地址 = ‘江苏省__市%’
Private Sub Command1_Click()
Dim str As String, s As String, k As Integer
s=Text1
Str=””
For k=List1.ListCount-1 to 0 Step-1
If InStr(List.List(k),s)>0 then
str=str&List.List(k)&” ”
End If
Next k
If str=””Then
Text2=”没有匹配的项目”
Else
Text2=str
End If
End Sub
程序运行时,在Text1中输入“京”,单击命令按钮,则在Text2中显示的内容是()。
A.京
B.北京 南京
C.南京
D.没有匹配的项目
A、SELECT TOP 10 SUM(UnitPrice) AS单价之和FROM Products
B、SELECT SUM(UnitPrice) AS单价之和TOP 10 FROM Products
C、SELECT TOP 10 COUNT(UnitPrice) AS单价之和FROM Products
D、SELECT SUM(UnitPrice) TOP 10 AS单价之和FROM Products
A、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
D、SELECT Name,UnitPrice FROM Products WHERE UnitPrice>6 AND UnitPrice <10<br>
A、SELECT MIN (UnitPrice) AS最高单价FROM Products
B、SELECT AVG (UnitPrice) AS最高单价FROM Products
C、SELECT MAX (UnitPrice) AS最高单价FROM Products
D、SELECT MAX UnitPrice AS最高单价FROM Products
A、select avg(price),type from book group by type
B、select count(price),type from book group by price
C、select avg(price),type from book group by price
D、select count (price),type from book group by type
A、select cid,count(distinct(cid)),sum(money) from orders group by cid
B、select cid,count(distinct(cid)),sum(money) from orders order by cid
C、select cid,count(cid),sum(money) from orders order by cid
D、select cid,count(cid),sum(money) from orders group by cid
A、select productid from orders where count(productid)>1
B、select productid from orders where max(productid)>1
C、select productid from orders where having count(productid)>1 group by productid
D、select productid from orders group by productid having count(productid)>1
A、Select * into customers from clients
B、Select into customers from clients
C、Insert into customers select * from clients
D、Insert customers select * from clients
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!