code_junkie

Best approach to SQL Server query using distinct

Nov 13th, 2011
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. SELECT * FROM TableA
  2. JOIN
  3. (SELECT DISTINCT IdA FROM TableB WHERE Date = '20090110') a
  4. ON a.IDA = TAbleA.IDA
  5. ORDER BY TableA.IdA
  6.  
  7. SELECT *
  8. FROM TableA A
  9. WHERE Exists( select B.IdA from TableB B where A.IdA = B.IdA and B.Date = '2009-01-10' )
  10. ORDER BY A.Id;
  11.  
  12. Select TableA.*, groupedTableB.OtherData
  13. From TableA
  14. Inner join
  15. (
  16. select TableB.IdA, Sum(TableB.Data) SummaryData
  17. from TableB where TableB.Date = '2009-01-10'
  18. group by TableB.IdA
  19.  
  20. ) groupedTableB on groupedTableB.IdA = TableA.IdA
  21.  
  22. distinct
  23.  
  24. distinct
Add Comment
Please, Sign In to add comment