代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/450692/7477760
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/450692/7477761
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/450692/7477762
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/450692/7477763
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';
www.eeworm.com/read/450692/7477764
sql 1.sql
SELECT name,year
FROM title
WHERE callnumber = (
SELECT callnumber
FROM author
WHERE lname = 'Churchill');
www.eeworm.com/read/450692/7477765
sql 4.sql
SELECT memno,fname,lname
FROM member
WHERE memno IN (
SELECT DISTINCT borrowermemno
FROM book
WHERE callnumber IN (
SELECT callnumber
FROM Author
WHERE lnam
www.eeworm.com/read/450692/7477766
sql 3.sql
SELECT m.memno,m.fname,m.lname
FROM member m
WHERE m.memno in (
SELECT b.borrowermemno
FROM title t,book b
WHERE t.callnumber=b.callnumber and t.name='Iliad')
and
m.memno in (
www.eeworm.com/read/450692/7477767
sql 8.sql
SELECT fname
FROM member
WHERE phonenumber LIKE '412%'
AND memno NOT IN (
SELECT b.borrowermemno
FROM book b,title t
WHERE b.callnumber = t.callnumber and t.name='Pitt Roads'
)
OR
www.eeworm.com/read/450426/7484174