代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/453719/7413846
sql script.sql
www.eeworm.com/read/453065/7427535
sql queries.sql
1.
SELECT libid,fname,Join_date
FROM MEMBER4
WHERE (libid LIKE 'A&%B%' ESCAPE '&' OR libid LIKE 'A&%B%') AND Join_date < TO_DATE('1997/11/30','YYYY/MM/DD')
2.
SELECT name,isbn,O.callnumber,SUM(
www.eeworm.com/read/452951/7428854
chm sql.chm
www.eeworm.com/read/452884/7431436
txt sql.txt
/*管理员信息表*/
CREATE TABLE [dbo].[admin] (
[adminUsername] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , /*管理员帐号*/
[adminPassword] [varchar] (32) COLLATE Chinese_PRC_CI_AS NULL /*管理员密码*/
www.eeworm.com/read/452798/7432657
sql createdb.sql
CREATE TABLE PUBLISHER(
PublisherID INTEGER,
Name VARCHAR(20),
Address VARCHAR(40),
CONSTRAINT PK_PUBLISHER PRIMARY KEY(PublisherID)
);
CREATE TABLE BOOK(
www.eeworm.com/read/452798/7432659
sql queries.sql
1.
select libid,fname,join_date
from member4
where (libid like 'Ax%B%' escape 'x' or libid like 'A&B%')
and join_date < to_date('1997/11/30', 'YYYY/MM/DD');
2.
SELECT f.name,f.isbn,f.callnum
www.eeworm.com/read/452798/7432662
sql 6.sql
select m.memno,m.fname,m.lname,count(*) AS borrowedbooks
from member m,book b
where m.memno=b.BorrowerMemNo
group by m.memno,m.fname,m.lname
having count(*)>=3
order by borrowedbooks desc;
www.eeworm.com/read/452798/7432663
sql 7.sql
SELECT memno,fname,lname
FROM member m
WHERE NOT EXISTS (
SELECT DISTINCT borrowermemno
FROM book b
WHERE m.memno = b.borrowermemno
);
www.eeworm.com/read/452798/7432664
sql 2.sql
SELECT distinct t.name
FROM title t,book b,member m
WHERE t.callnumber=b.callnumber and b.borrowermemno=m.memno
and (m.fname='John' or m.fname='Susan');
www.eeworm.com/read/452798/7432665
sql 5.sql
SELECT m.phonenumber
FROM member m,book b,author a
WHERE b.callnumber=a.callnumber and memno=b.borrowermemno and a.lname='Tanenbaum';