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+
相关阅读
大家旧电脑都是怎么处理的？求推荐2个笔记本?pogoplug装archlinux后能用usb hub吗？SanDisk Extreme 240GB ssd咋样？请帮忙配个5千左右的台式机n54l dsm 4.1 upgrade to 4.2W500升级840 pro ssd可行否dvi能不能split啊？费城搬家出售Stiga 乒乓球桌合金装备2 PC中文版，用win764位玩不了，不知道为什么，哪位指点下！？据说，用mac的最大好处求推荐个轻便的电脑台机频繁重启thinkpad t430s 还在保修期 可是硬盘坏了Don't buy NAS server, buy Dell PowerEdge 2950microcenter有什么cpu和mb的deal吗？Think pad系列哪款好？centos上怎么装netatalk？想试一下键盘的手感 去什么店里试好呢求教放video如何完美显示？
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章，不代表同意其说法或描述，仅为提供更多信息，也不构成任何建议。文章信息的合法性及真实性由其作者负责，与Redian.news及其运营公司无关。欢迎投稿，如发现稿件侵权，或作者不愿在本网发表文章，请版权拥有者通知本网处理。