logo
Redian新闻
>未名空间
>Hardware - 计算机硬件
>
准备入一个显示器，dell 2412m，或者2413？
avatar
准备入一个显示器，dell 2412m，或者2413？# Hardware - 计算机硬件
h*3
1 楼
可能讨论过:
Table "books" has columns BOOK_ID, BOOK_TITLE, BOOK_AUTHOR, PRICE, PUBLISH_
DATE. Delete most expensive book from books table.
我try 了
delete max(price), author, publish_date,book_id from books;
sub-query
delete * from books where price in (select max(price) from books);
self-join
delete * from books b1, books b2 where b1.price = b2.price and b2.price in
select max(price);
none of them work. Can anybody tell me one executable SQL statement?
Thanks.
avatar
h*u
3 楼
主要用来上网，编编程序，看看视频啥的。是不是就没有必要上2413了吧？
2412m是不是就够用了？了解的同学给讲讲
(这几天这两个还都有点小deal)
avatar
g*1
4 楼
delete from ....
avatar
M*5
5 楼
给的比较少
avatar
w*x
6 楼
2413现在不如2410划算...
avatar
t*j
7 楼
delete 肯定是 delete一个row，全部的column啦。

【在 h******3 的大作中提到】
: 可能讨论过:
: Table "books" has columns BOOK_ID, BOOK_TITLE, BOOK_AUTHOR, PRICE, PUBLISH_
: DATE. Delete most expensive book from books table.
: 我try 了
: delete max(price), author, publish_date,book_id from books;
: sub-query
: delete * from books where price in (select max(price) from books);
: self-join
: delete * from books b1, books b2 where b1.price = b2.price and b2.price in
: select max(price);
avatar
B*y
8 楼
Chase存1W才给100刀，这个貌似也不错了，怎么还少呢？

【在 M*********5 的大作中提到】
: 给的比较少
avatar
t*k
9 楼
where is the deal xian?
avatar
p*s
10 楼
try to get rid of your * after delete in your second statement

【在 h******3 的大作中提到】
: 可能讨论过:
: Table "books" has columns BOOK_ID, BOOK_TITLE, BOOK_AUTHOR, PRICE, PUBLISH_
: DATE. Delete most expensive book from books table.
: 我try 了
: delete max(price), author, publish_date,book_id from books;
: sub-query
: delete * from books where price in (select max(price) from books);
: self-join
: delete * from books b1, books b2 where b1.price = b2.price and b2.price in
: select max(price);
avatar
g*9
11 楼
我上个星期跳了，嘿嘿……
avatar
h*u
12 楼
2412m newegg 10% off
2413 10% off with coupon code at dell website, maybe today is the last day
for this coupon.

【在 t***k 的大作中提到】
: where is the deal xian?
avatar
d*e
13 楼
delete from books
where price = (select max(price) from books);
commit;

【在 h******3 的大作中提到】
: 可能讨论过:
: Table "books" has columns BOOK_ID, BOOK_TITLE, BOOK_AUTHOR, PRICE, PUBLISH_
: DATE. Delete most expensive book from books table.
: 我try 了
: delete max(price), author, publish_date,book_id from books;
: sub-query
: delete * from books where price in (select max(price) from books);
: self-join
: delete * from books b1, books b2 where b1.price = b2.price and b2.price in
: select max(price);
avatar
W*y
14 楼
第二个50要一年以后
avatar
x*y
15 楼
In mySQL,
delete from books
order by price desc
limit 1 \g

【在 h******3 的大作中提到】
: 可能讨论过:
: Table "books" has columns BOOK_ID, BOOK_TITLE, BOOK_AUTHOR, PRICE, PUBLISH_
: DATE. Delete most expensive book from books table.
: 我try 了
: delete max(price), author, publish_date,book_id from books;
: sub-query
: delete * from books where price in (select max(price) from books);
: self-join
: delete * from books b1, books b2 where b1.price = b2.price and b2.price in
: select max(price);
avatar
t*8
16 楼
MARK一下，我空了就跳
avatar
h*3
17 楼
tried
delete from books where price = (select max(price) from books);
it doesn't work. Error code: 1093, you can't specify target table "books"
for update in from clause.
avatar
B*y
18 楼
跳了几个？是不是把准备存Chase的1W分10次存US Bank，就可以现赚500刀Visa Card，
一年以后再收500刀现金，哈哈哈哈。。。

【在 g****9 的大作中提到】
: 我上个星期跳了，嘿嘿……
avatar
h*3
19 楼
it works. :P.

【在 x***y 的大作中提到】
: In mySQL,
: delete from books
: order by price desc
: limit 1 \g
avatar
x*i
20 楼
这个活动什么时候截至?
avatar
b*g
21 楼
请问这是每1000就送100？还是一共只送一个100？

【在 B******y 的大作中提到】
: 怎么冒似没有人感兴趣呢？开户就给$50的Visa Card，$1000 存满一年，只要没有掉下
: 过1000，就再送$50。这个应该比Chase的那个1W刀的强吧？
: http://usbank.com/start/start.html?icid=PB_8827&WT.mc_id=r8827&
avatar
a*o
22 楼
they will do a hard credit pull even for existing customers for opening a
savings account.
avatar
a*o
23 楼
Warning: US Bank conducts a hard credit inquiry when you open accounts with
them. This lowers your credit score and can damage your credit rating. So be
careful about opening accounts with them.
avatar
d*y
24 楼

with
be
这么狠，早知道上次checking和saving一起来了的。

【在 a****o 的大作中提到】
: Warning: US Bank conducts a hard credit inquiry when you open accounts with
: them. This lowers your credit score and can damage your credit rating. So be
: careful about opening accounts with them.
avatar
B*y
25 楼
这个。。。如果我用老爸老妈的护照能不能开户？他们没有SS，也没有信用记录。

with
be

【在 a****o 的大作中提到】
: Warning: US Bank conducts a hard credit inquiry when you open accounts with
: them. This lowers your credit score and can damage your credit rating. So be
: careful about opening accounts with them.
avatar
c*7
26 楼
放一年太久了。别的开户就给$100+
avatar
B*y
27 楼
Link？

【在 c*********7 的大作中提到】
: 放一年太久了。别的开户就给$100+
相关阅读
请教怎么显示到多个显示器上求教一个问题美国多所学校免费为师生配备iPadzz装7， 为啥要刷bios呢求推荐性能好的laptop大伙家里的台式机寿命一般几年？Ultrasharp的TN屏怎么样啊？如何通过DOS 命令拷文件Netgear路由器WNR3500L的username.password?ssd到手了，接下来怎么搞？Phenom II Dual-Core Mobile N660 Processor 3.0GHz 好用吗?求教：关于thinkpad x201加内存ssd硬盘与主板兼容求助牛奶打翻到键盘上了 :(这个Cisco Linksys E2000 Wireless N Dual Band refurbished $40价格如何？brite view的播放器能升级吗？呵呵，MC的i7-950又降回$200了MC今天online卖SB了newegg已经ship的order还能cancel吗？还是sony vaio z 给力
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。