由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - How To Retrieve This Record? 谢谢
相关主题
Help for VB 6 and MS Access DBHow to store data locally?
Any faster way to retrieve only one record?What are two methods of retrieving SQL?
how to fetch the first record from a table?recursive sql?
请问一个SQL语句的优化问题A sql question
SQL server 2000有hidden records吗?怎样实现这个query
怎么用Update实现这个?Oracle error code 12638?
[SQL求助] 取每个group的第一个record高手救命
问个sql的问题吧,搞不出来了. (转载)ODBC help!
相关话题的讨论汇总
话题: retrieve话题: record话题: fields话题: database话题: value
进入Database版参与讨论
1 (共1页)
l***s
发帖数: 28
1
retrieve a record which has a same value for all the 50 fields it has from a
big database..thanks.
b******l
发帖数: 261
2
SELECT * FROM T
WHERE MAX(C1,C2,...C50) = MIN(C1,C2,..C50)

【在 l***s 的大作中提到】
: retrieve a record which has a same value for all the 50 fields it has from a
: big database..thanks.

l***s
发帖数: 28
3
hey, this is smart ! thanks a lot ! :)

a

【在 b******l 的大作中提到】
: SELECT * FROM T
: WHERE MAX(C1,C2,...C50) = MIN(C1,C2,..C50)

j**i
发帖数: 419
4
this is for what?
access, oracle,@@
not good for certain things bah

from

【在 l***s 的大作中提到】
: hey, this is smart ! thanks a lot ! :)
:
: a

1 (共1页)
进入Database版参与讨论
相关主题
ODBC help!SQL server 2000有hidden records吗?
Which server shoule I use怎么用Update实现这个?
JDBC: How to get Identity after insert[SQL求助] 取每个group的第一个record
link website to database问个sql的问题吧,搞不出来了. (转载)
Help for VB 6 and MS Access DBHow to store data locally?
Any faster way to retrieve only one record?What are two methods of retrieving SQL?
how to fetch the first record from a table?recursive sql?
请问一个SQL语句的优化问题A sql question
相关话题的讨论汇总
话题: retrieve话题: record话题: fields话题: database话题: value