Sql Query最多为no [英] Sql Query to max of no

问题描述

亲爱的朋友们，我有Table OpeningBalance ，字段是

 TrnsNo CustomerName 
  1  Kiran 
  2  Nagappa 
  3  prasanth 
  4  kiran 

现在我想选择客户名称kiran并使用其最大TrnsNO

解决方案

访问这里....





http://stackoverflow.com/questions/1438978/sql -query-to-get-max-value-based-on-different-max-value-given-multiple-records [ ^ ]

 选择 max（TrnsNo）来自 OpeningBalance 其中 CustomerName = '  Kiran' 

< pre lang =sql> SELECT *
FROM OpeningsBalance
WHERE 在中（选择 TrnsNo 来自 OpeningsBalance 其中​​ Customername = ' TESTT'）;

Dear Friends, i have Table OpeningBalance and fields are

TrnsNo  CustomerName
  1        Kiran
  2        Nagappa
  3        prasanth
  4        kiran

Now i want to select customer name kiran and with its maximum TrnsNO

解决方案

visit here....


http://stackoverflow.com/questions/1438978/sql-query-to-get-max-value-based-on-different-max-value-given-multiple-records[^]

Select max(TrnsNo) from OpeningBalance where CustomerName='Kiran'

SELECT *
FROM OpeningsBalance
WHERE TrnsNo in(select TrnsNo from OpeningsBalance where Customername='TESTT');

这篇关于Sql Query最多为no的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！