如何建立一条sql语句使在a表中生成一条数据同时b表也生成一条
使用循环语句，可以插入任意的数据。
参考代码：
delete from whilestu1;
commit;
DECLARE
num1 number;
maxstuid number;
age number;
birthday date;
begin
num1:=1;
WHILE num1–获取最大的stuid
select max(stuid)+1 into maxstuid from whilestu1;
if maxstuid is null then
maxstuid:=1;
end if;
birthday:=sysdate-ROUND(DBMS_RANDOM.VALUE(300,600),0);
age:=ROUND(DBMS_RANDOM.VALUE(18,40),0);
–插入数据
insert into whilestu1(stuid,stuName,age,birthday)
values (maxstuid，’学员’||cast(maxstuid as varchar2(50)),age,birthday);
commit;
num1:=num1+1;
END LOOP;
end;
/
SQL在查询结果中选取某一条数据
— 用的啥数据库也不写清楚。。。
— MS sql server2005以上，ORACLE
select * from (
select row_number() over ( order by starttime asc) as rownum,* from steriworkrecord where starttime between ‘2013-11-1’ and ‘2013-12-31’
) a
where rownum between 2 and 10– 【注意（ order by starttime asc）是你排序的方式asc升序，desc降序】
========================================================
— ORACLE还可以
select * from (
select rownum as n,* from steriworkrecord
where starttime between ‘2013-11-1’ and ‘2013-12-31’
) a
where a.n between 2 and 10==========================================================
— MYSQL,postgreSQL似乎只能标量子查询
SELECT *FROM (
SELECT a.*,(
SELECT count(*) FROM steriworkrecordb WHERE b.ID
from steriworkrecorda
) ts
where ts.n between 2 and 10
— 【注意b.ID
— 代码都忙你实际测试了ok
如何用SQL语句取出数据库中的特定一条数据
通过查询语句select * from user where id=1
我不知道你这个username指的是不是字段，如果是要取出表中某个字段的值。
可以通过select 字段名1，字段名2 … from user where id=1。
— MS sql server2005以上，ORACLE
select * from (
select row_number() over ( order by starttime asc) as rownum,* from steriworkrecord
where starttime between ‘2013-11-1’ and ‘2013-12-31’
) a
where rownum between 2 and 10
— 【注意（ order by starttime asc）是你排序的方式asc升序，desc降序】
— ORACLE还可以
select * from (
select rownum as n,* from steriworkrecord
where starttime between ‘2013-11-1’ and ‘2013-12-31’
) a
where a.n between 2 and 10
— MYSQL,postgreSQL似乎只能标量子查询
SELECT *FROM (
SELECT a.*,(
SELECT count(*) FROM steriworkrecordb WHERE b.ID
from steriworkrecorda
) ts
where ts.n between 2 and 10
— 【注意b.ID
以上就是如何使用一条SQL语句同时在A表和B表中生成一条数据的详细内容，更多请关注【创想鸟】其它相关文章！
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/2528275.html
