⑴ sql 最小值选取
select min(left_day),atrate from Act_Table
where Act=1 group by atrate
⑵ SQL从查询结果中查最小值
SELECT C.CategoryID, C.CategoryName, SUM(F.CommentNO) AS SumComment
FROM Category AS C, Feedback AS F, Article AS A
WHERE C.CategoryID=A.CategoryID AND A.ArticleID=F.ArticleID
GROUP BY C.CategoryID, C.CategoryName having SUM(F.CommentNO)=
(select min(t1.SumComment1) from
(SELECT SUM(F.CommentNO) AS SumComment1
FROM Category AS C, Feedback AS F, Article AS A
WHERE C.CategoryID=A.CategoryID AND A.ArticleID=F.ArticleID
GROUP BY C.CategoryID, C.CategoryName) as t1)
这样试试
⑶ 页面搜索时SQL表中都多条相同的数据 怎么只选择序号最小的这条
selecttop1*fromhyzwherename='%"+name+"%'
⑷ sql 语句 一列中的最小值
select riqi, from table_name where =(select min() from table_name where riqi between '20000101' and '20000131')
⑸ oracle sql查询完成分组并只返回每组的最小最大值
我的测试表里有7条数据。每3条数据分作一组求最小和最大id。
WITHtmp("id")AS
(SELECT1FROMDUALUNIONALL
SELECT2FROMDUALUNIONALL
SELECT3FROMDUALUNIONALL
SELECT4FROMDUALUNIONALL
SELECT5FROMDUALUNIONALL
SELECT6FROMDUALUNIONALL
SELECT7FROMDUAL
)
selectmin("id")min_id,max("id")max_id
from(
select"id",row_number()over(orderby"id")seqfromtmp
)t
groupbyfloor((seq-1)/3)
orderbyfloor((seq-1)/3)结果如下：
楼主把上面语句里的3换成100就行了。
⑹ sql 几个字段最小值
我只写6个字段,你可以扩展
select case when jiage_k> jiage_c then jiage_c else jiage_k end as jiage_min from (
select case when jiage_a> jiage_b then jiage_b else jiage_a end as jiage_k,jiage_c from (
select case when jiage1>jiage2 then jiage2 else jiage1 end as jiage_a,
case when jiage3>jiage4 then jiage3 else jiage4 end as jiage_b,
case when jiage5>jiage6 then jiage5 else jiage6 end as jiage_c
from 表名) a
) b
这样就可以查出没行记录中最小的值是多少 那如果还想知道字段名 可以left join 并且用case去对比就知道了
⑺ 如何删除sql中某个字段出现重复的数据，且只保留id最小的
⑻ 如何在SQL中搜寻表中最小和第二小的数据我可以排序出来 但是目标是只要这2条记录~
最小：
SELECT MIN（字段）
FROM 表
第二小：
SELECT MIN（字段）
FROM 表
WHERE 字段>(SELECT MIN（字段）FROM 表)
两个都要：
SELECT TOP 2 字段
FROM 表
ORDER BY 字段
⑼ sql 取分组 最小值
select USERTYPE from CONFIG_USER group by USERTYPE ORDER BY USERTYPE DESC
先分组再排序 取第一个就行了
⑽ SQL取出值最小的一条数据
补充楼上：
select min(字段名称）as 最小值 from 表名