SQL 冷笑話 (圓窗) (转载)# Joke - 肚皮舞运动
i*a
1 楼
【 以下文字转载自 Database 讨论区 】
发信人: iMaJia (iMac,iPod,iPad,i馬甲), 信区: Database
标 题: SQL 冷笑話 (圓窗)
发信站: BBS 未名空间站 (Fri Feb 4 16:49:27 2011, 美东)
User: I want to find two students with the lowest scores.
DBA: OK, so we want select top 2 StudentName from ExameResult order by
Score asc
User: No, not the top 2, I want the bottom 2
DBA: Yes, that's why I am selecting top 2 order by score in ascending
order
User: No no no! Do you speak english language?! I want the bottom 2 by
score in descending order!
DBA: I understand. But there is no bottom in SQL language.
User: Then maybe we should use NoSQL!
发信人: iMaJia (iMac,iPod,iPad,i馬甲), 信区: Database
标 题: SQL 冷笑話 (圓窗)
发信站: BBS 未名空间站 (Fri Feb 4 16:49:27 2011, 美东)
User: I want to find two students with the lowest scores.
DBA: OK, so we want select top 2 StudentName from ExameResult order by
Score asc
User: No, not the top 2, I want the bottom 2
DBA: Yes, that's why I am selecting top 2 order by score in ascending
order
User: No no no! Do you speak english language?! I want the bottom 2 by
score in descending order!
DBA: I understand. But there is no bottom in SQL language.
User: Then maybe we should use NoSQL!