When use the EXISTS introduced the subquery, specify only one expression in the select list. Please-CodePudding

Home > database > When use the EXISTS introduced the subquery, specify only one expression in the select list. Please

When use the EXISTS introduced the subquery, specify only one expression in the select list. Please

Time：09-15

Query: select * from student where the student. The sno not in (select group0, sno, group0. Sno1, group0, sno2, group0. Sno3 from group0)

Prompt error!!!!!

CodePudding user response:

Can only use the exists only can specify multiple columns

CodePudding user response:

reference 1st floor xiaoxiangqing response:

can only use the exists only can specify multiple columns

You can say how to use the exists?

Page link：https//www.codepudding.com/database/439.html

Prev:Pb12 webbrowers control newwindow2 event how can obtain the popup web address

Next:raw

Tags：

problems

Links：
CodePudding