How to use one SQL statement to generate a piece of data in table A and table B at the same time

How to create a sql statement to generate a piece of data in table a and table b at the same time

Using loop statements, you can insert arbitrary data.

Reference Code:

delete from whilestu1;

commit;

DECLARE

num1 number;

maxstuid number;

age number;

birthday date;

begin

num1:=1;

WHILE num1--Get the largest stud

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 data

insert into whilestu1(stuid,stuName,age,birthday)

values ​​(maxstuid,'student'||cast(maxstuid as varchar2(50)),age,birthday);

commit;

num1:=num1 1;

END LOOP;

end;

/

SQL selects a certain piece of data in the query results

-- I don’t know clearly what database is used. . .

-- MS sql server2005 or above, 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-- [Note (order by starttime asc) is the way you sort, asc ascending, desc descending]

================================================ =========

-- ORACLE is OK

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 seems to only be able to use scalar subqueries

SELECT *FROM (

SELECT a.*,(

SELECT count(*) FROM steriworkrecordb WHERE b.ID

from steriworkrecorda

) ts

where ts.n between 2 and 10

-- [Note that b.ID

-- The code is busy and you actually tested it ok

How to use SQL statements to retrieve a specific piece of data from the database

Select * from user where id=1

I don’t know if your username refers to a field. If you want to retrieve the value of a field in the table.

You can select field name 1, field name 2... from user where id=1.

-- MS sql server2005 or above, 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

-- [Note (order by starttime asc) is your sorting method asc ascending order, desc descending order]

-- ORACLE is OK

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 seems to only be able to use scalar subqueries

SELECT *FROM (

SELECT a.*,(

SELECT count(*) FROM steriworkrecordb WHERE b.ID

from steriworkrecorda

) ts

where ts.n between 2 and 10

-- [Note that b.ID

The above is the detailed content of How to use one SQL statement to generate a piece of data in table A and table B at the same time. For more information, please follow other related articles on the PHP Chinese website!