May 17, 2012, 02:05:07 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Please support SEO4smf further development donating here or use paypal button from left menu.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Please support SEO4smf further development donating here or use paypal button from left menu.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

SQL aggregation functions

 (Read 263 times)
0 Members and 1 Guest are viewing this topic.
oooxxooo
Newbie
*

Points: 0
Offline Offline

Posts: 3
« on: January 19, 2012, 02:07:58 »
The GROUP BY clause is used to project rows having common values into a smaller set of rows. GROUP BY is often used in conjunction with SQL aggregation functions or to eliminate duplicate rows from a result set. The WHERE clause is applied before the GROUP BY clause.



κατασκευη ιστοσελιδων
chauffeur service sydney
Logged


p.akhilreddy4u
Newbie
*

Points: 0
Offline Offline

Posts: 2


WWW
« Reply #1 on: February 13, 2012, 00:38:05 »
The syntax is

Code:
SELECT [Group by columns | Group by functions]
FROM [Table Name]
Group by group_by_columns

An example is

Code:
SELECT department_id, count(1)
FROM    employees
Group by departments;
Logged
Find Command in unix
Grep command in unix
Informatica, unix, oracle
onzevil12
Newbie
*

Points: 0
Offline Offline

Posts: 2
« Reply #2 on: February 26, 2012, 00:45:50 »
it became known that a lot of good in it.
Logged
How to reduce the grabbing that occurs. คาสิโนออนไลน์  and is best known for playing the game in คาสิโนออนไลน์ it.
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!