仅显示一堆记录中的一个记录. [英] display only one record from bunch of record.

问题描述

hii ..

我在sql服务器查询中有一个问题.我只想显示一堆记录中的一条记录，怎么可能呢?

查询:

hii..

i have one problem in sql server query..i want to display only one record from bunch of record so how can it possible??

Query:

SELECT    distinct  tbl_ProcessSalary.PaySlipMonth, tbl_ProcessSalary.PSYear, tbl_ProcessSalary.ComputationType, tbl_ProcessSalary.PSSalary, tbl_ReimbExpenseClaim.MonthFor, 
                      tbl_ReimbExpenseClaim.YearFor, tbl_ReimbExpenseClaim.Status, tbl_ReimbEmployeeExpenseMaster.ReimbApprovedAmt, 
                      tbl_ReimbEmployeeExpenseMaster.ReimbStatus, tbl_ReimbEmployeeExpenseMaster.ReimbMonth, tbl_ReimbEmployeeExpenseMaster.ReimbYear, 
                      tbl_Employee.EmployeeID, tbl_ReimbExpenseClaim.EmpID, tbl_ReimbExpenseClaim.ReimbExpClaimID,(select  sum(tbl_ReimbEmployeeExpenseMaster.ReimbApprovedAmt) as TotalExpense from tbl_ReimbEmployeeExpenseMaster INNER JOIN
                      tbl_ReimbExpenseClaim ON tbl_ReimbEmployeeExpenseMaster.ReimbExpClaimID = tbl_ReimbExpenseClaim.ReimbExpClaimID where tbl_ReimbExpenseClaim.EmpID='2112'   and tbl_ReimbEmployeeExpenseMaster.ReimbStatus='Approved')
FROM         tbl_Employee INNER JOIN
                      tbl_ProcessSalary ON tbl_Employee.EmployeeID = tbl_ProcessSalary.EmployeeID INNER JOIN
                      tbl_ReimbExpenseClaim ON tbl_ProcessSalary.EmployeeID = tbl_ReimbExpenseClaim.EmpID INNER JOIN
                      tbl_ReimbEmployeeExpenseMaster ON tbl_ReimbExpenseClaim.ReimbExpClaimID = tbl_ReimbEmployeeExpenseMaster.ReimbExpClaimID where tbl_Employee.EmployeeID='2112' and tbl_ProcessSalary.ComputationType='Reimbursement'  and tbl_ReimbExpenseClaim.YearFor='2012'  and tbl_ProcessSalary.PaySlipMonth='1' and tbl_ReimbExpenseClaim.MonthFor='1' and tbl_ReimbEmployeeExpenseMaster.ReimbStatus='Approved' 

它给了我四条记录，但是我只想在输出中显示一条记录，所以给我一个解决方案...

And its give me four record but i want to display only one record in output so give me a solution...

推荐答案

如果您没有任何条件要从这4条记录中筛选出，则可以选择"Top Clause"(顶部子句)

请参阅此以获取最高级条款
http://msdn.microsoft.com/en-us/library/ms189463％28v = sql.90％29.aspx [ ^ ]
http ://blog.sqlauthority.com/2008/03/02/sql-server-how-to-retrieve-top-and-bottom-rows-together-using-t-sql/ [ ^ ]

希望对您有所帮助.

Hi,

if you do not any condition to filter out of that 4 records, you can go for "Top Clause"

refer this for Top Clause
http://msdn.microsoft.com/en-us/library/ms189463%28v=sql.90%29.aspx[^]
http://blog.sqlauthority.com/2008/03/02/sql-server-how-to-retrieve-top-and-bottom-rows-together-using-t-sql/[^]

hope it helps.

这篇关于仅显示一堆记录中的一个记录.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！