Comparison Between TeraData/Oracle/SQL Server 2005

Function Name
RDBMS (Teradata / Oracle)
Function Description
Teradata Equivalent
Microsoft SQL Server 2005 Equivalent
Oracle Equivalent
Sample / Example (in SQL Server)
Sample / Example(in Oracle)
Sample / Example(in Teradata)
REMARKS
Aggregate Functions (SUM)
TD/Oracle
Aggreagate Operators are used to perform computations on values in a specified way, these operators returns Single Line Answers only OUT PUT is Sum(salary_amount)415400.00
Sum
Sum
Sum
select sum (salary_amount) from employee;
select sum (salary_amount) from employee;
select sum (salary_amount) from employee;
Successfully Executed
Aggregate Functions (AVG)
TD/Oracle
AVG Operator give You only the Average of the Specific Column OUT PUT is Average(salary_amount) 41540.00
Avg
Avg
Avg
select Avg (salary_amount) from employee;
select Avg (salary_amount) from employee;
select Avg (salary_amount) from employee;
Successfully Executed
Aggregate Functions (MIN)
TD/Oracle
MIN operator give you only the Minumun value. OUT PUT is Minimum(salary_amount) 24500.00
Min
Min
Min
select Min (salary_amount) from employee;
select Min (salary_amount) from employee;
select Min (salary_amount) from employee;
Successfully Executed
Aggregate Functions (MAX)
TD/Oracle
MAX Operator give you only the Maximun value. OUT PUT is Maximum(salary_amount) 60000.00
Max
Max
Max
select Max (salary_amount) from employee;
select Max (salary_amount) from employee;
select Max (salary_amount) from employee;
Successfully Executed
Window Aggregate Function Using( With)
Teradata
Window Aggregate Functions are Used to Perform (OLAP) On-Line-Analytical-Processing, Which permits Analysis and Mining of Data in the Data Warehouse or Data Mart.OUT PUT is last_name salary_amount department_number-------------------- ------------- -----------------Johnson 36300.00 401Rogers 46000.00 401Hopkin 31000.00 403Hopkin 37900.00 403 ----------------- Total_Count 4
With
count(8)
count(8)
select count(8),department_numberfrom employeewhere department_number in (401,403)Group by department_number
select count(8),department_numberfrom employeewhere department_number in (401,403)Group by department_number
select Last_name,salary_amount, Department_number from Employeewhere department_number in(401,403)WITH count(department_number) (Title 'Total_Count')order by 3,1;
Successfully Executed
Window Aggregate Function Using (With, By for Group Counts)
Teradata
Window Aggregate Functions are Used to Perform (OLAP) On-Line-Analytical-Processing, Which permits Analysis and Mining of Data in the Data Warehouse or Data Mart. Using the With..By Clause allows Generation of Sub-Total Counts based on Groupings identified in the By Clause. OUT PUT is last_name salary_amount department_number-------------------- ------------- -----------------Rogers 46000.00 401Johnson 36300.00 401 ----------------- Total_Count 2Hopkin 31000.00 403Hopkin 37900.00 403 ----------------- Total_Count 2
With…By
count(*)
count(*)
select department_number,job_code,count(*)from employeegroup by department_number,job_code
select department_number,job_code,count(*)from employeegroup by department_number,job_code
select Last_name,salary_amount, Department_number from Employeewhere department_number in(401,403)WITH count(department_number) (Title 'Total_Count') by department_number;
Successfully Executed

Source : Khan Iqra University