code_junkie

Using ORDER BY on SELECT DISTINCT in TSQL

Nov 13th, 2011
177
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.20 KB | None | 0 0
  1. SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
  2. FROM dbo.ProviderProcessGeneratedDate
  3. ORDER BY GeneratedDate
  4.  
  5. SELECT CONVERT(Varchar(10), a.GeneratedDate, 101) AS GeneratedDate
  6. FROM (SELECT DISTINCT Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101)) AS GeneratedDate
  7. FROM dbo.ProviderProcessGeneratedDate) a
  8. ORDER BY a.GeneratedDate DESC
  9.  
  10. SELECT DISTINCT Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101))
  11. AS GeneratedDate,
  12. A.GeneratedDate OrderByDate
  13. FROM dbo.ProviderProcessGeneratedDate A
  14. Order By A.GeneratedDate Desc
  15.  
  16. WITH Dates(GeneratedDate) AS
  17. (
  18. SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
  19. FROM dbo.ProviderProcessGeneratedDate
  20. )
  21.  
  22. SELECT GeneratedDate FROM Dates ORDER BY GeneratedDate
  23.  
  24. ORDER BY ProviderProcessGeneratedDate.GenerateDate
  25.  
  26. SELECT
  27. Convert(DATETIME,CONVERT(Varchar(10), GeneratedDate, 101))
  28. FROM
  29. ProviderProcessGeneratedDate
  30. GROUP BY
  31. GeneratedDate
  32. ORDER BY
  33. GeneratedDate
  34.  
  35. SELECT
  36. Convert(DATETIME,CONVERT(Varchar(10), DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0), 101))
  37. FROM
  38. ProviderProcessGeneratedDate
  39. GROUP BY
  40. DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0)
  41. ORDER BY
  42. DATEADD(DAY, DATEDIFF(DAY, 0, GeneratedDate), 0)
  43.  
  44. ORDER BY dbo.ProviderProcessGeneratedDate.GeneratedDate
  45.  
  46. FROM dbo.ProviderProcessGeneratedDate ppgd
  47.  
  48. SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDateString
  49. FROM dbo.ProviderProcessGeneratedDate
  50. ORDER BY GeneratedDate
  51.  
  52. SELECT DISTINCT CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
  53. FROM dbo.ProviderProcessGeneratedDate
  54. ORDER BY CONVERT(Varchar(10), GeneratedDate, 112)
  55.  
  56. SELECT
  57. CONVERT(Varchar(10), GeneratedDate, 101) AS GeneratedDate
  58. FROM
  59. dbo.ProviderProcessGeneratedDate AS BaseDates
  60. GROUP BY
  61. BaseDates.GeneratedDate,
  62. CONVERT(Varchar(10), GeneratedDate, 101)
  63. ORDER BY
  64. BaseDates.GeneratedDate
  65.  
  66. select * from
  67. (
  68. SELECT DISTINCT CONVERT(varchar, GeneratedDate, 101) AS GeneratedDate
  69. FROM ProviderProcessGeneratedDate
  70. -- no need for ORDER BY, it is implicitly performed when DISTINCTing rows
  71. ) as y
  72. order by convert(datetime, GeneratedDate) DESC
Add Comment
Please, Sign In to add comment