sql union into（cut into造句）

1. plsql快速写好一个表的插入语句
2. cut into造句
3. 用SQL查询，从学生信息表和教师信息表中查询同姓的教师和学生的姓名

plsql快速写好一个表的插入语句

insertintotable_a(列1，列2)

select值1，值2

unionall

select值3，值4

这样不就可以了吗？

cut into造句

1.Chips should be cut into uniform size and thickness.

2.She had her long hair cut into a boyish crop.

3.The wood was cut into large sheets of veneer.

4.Roll out the pastry and cut into narrow strips.

5.Leslie lightens her hair and has now had it cut into a short, feathered style.

6.The pack straps are too tight. They cut into the flesh.

7.The union made the company pay higher wages, which cut into the profits.

8.The glass cut into her hand.

用SQL查询，从学生信息表和教师信息表中查询同姓的教师和学生的姓名

都没有表结构……我自己建表吧

use tempdb

go

create table T(TName varchar(20))

create table S(SName varchar(20))

insert into T select '张老师' union all select '王老师'

insert into S select '李学生' union all select '张学生'

select * from T

到此，以上就是小编对于的问题就介绍到这了，希望介绍的3点解答对大家有用，有任何问题和不懂的，欢迎各位老师在评论区讨论，给我留言。