关于数据库语法问题。多条件查询

[qq_21829433]

查询
a字段等于1 ； b字段等于=2 ； c 字段中的 最大值。。。语法怎么写。
问题有点绕啊。。百度了一圈，把自己百度蒙圈了，应该有多条件查询的语法来着，，忘了，请路过的帮忙看看

[山的那边还是山~]

a=1 and b=2 and max(c)=XXX

[卖水果的net]

select top 1 * from t where a = 1 and b = 2 order by c desc

[吉普赛的歌]

USE tempdb
GO
IF OBJECT_ID('dbo.[t]') IS NOT NULL 
	DROP TABLE dbo.[t]
GO
CREATE TABLE dbo.[t](
[a] INT
,[b] INT
,[c] INT
)
GO
SET NOCOUNT ON
INSERT INTO dbo.[t] VALUES(1,2,3)
INSERT INTO dbo.[t] VALUES(1,2,4)
INSERT INTO dbo.[t] VALUES(2,1,3)
GO
--- 以上为测试数据 ----

SELECT MAX(c) AS cMax
FROM t
WHERE a=1 AND b=2
/*
cMax
-----------
4
*/

[二月十六]

Select max(c)c from 表名 where a=1 and b=2

[doloopcn]

SELECT MAX(C) FROM YOURTABLE
WHERE (a=1 and b=2)

[早起晚睡]

楼上正解还要十个字真服了！！！

[qq_25073223]

 select *from (
select * , row_number() over (order by c desc ) as keyId  ) as t where t.keyId =1 

row_number可以解决题主的疑问，而且非常清晰，请参阅

[qq_25073223]

select *from (
select * , 
row_number() 
   over (order by c desc ) as keyId  ) 
    as t 
  where t.keyId =1  
    and t.a =1 and t.b =2 

[qq_41594604]

SELECT a,b,max(C) C
FROM 表
WHERE a=1 and b=2
GROUP BY a,b
从表中超出a=1,b=2的所有字段，并根据ab分组，得到a,b相同中最大的C