Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kavi12345
Starting Member
19 Posts |
 Posted - 2012-03-05 : 07:16:15
|
| Hi,Can give clear explain with example about OrderBy,GroupBy,Having and distinct?? what is the ultimate differents between "where" and "having" condition?? Thanks in advancekavichakravarthi.R |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2012-03-05 : 07:20:56
|
| are you doing a course? If so ask your tutor.you should look up each term in the sql server documentation. http://msdn.microsoft.com/en-us/library/ms130214.aspxvery quickly: ORRDER BY : orders the result set by the columns / specified GROUP BY : Collapses the result set into 'groups' of the columns specified DISTINCT : Returns the DISTINCT rows (so discards duplicates entries -- of all the columns ) WHERE : Filters the results before a GROUP BY is performed HAVING : Filters the results AFTER a GROUP BY is performedCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
 |
|
|
|
|
|
diff between OrderBY,GroupBy,Having and Distinct?