A derived column is a result of a calculation (most of the time mathematical) that happens during the SQL query processing and generates a new column which is not part of the original table definition. For example, in our table we have salary column present but when we want to extract a percentage of the [...]
Author's Archive Page 5
SELECT Query with Examples
In this Section we are going to try out all possible simple SELECT queries. First lets create a sample table called emp which should have rows like the following. emp_no dept_no first_name last_name salary 7000 114 Read Vitamin 62,000 4000 113 John Row 55,000 5000 114 Robert Howard 65,000 2000 112 Larry King 60,000 1000 [...]
More From Choose a category
Recently in Choose a category
Latest in Choose a category
Tags Cloud
Recent Comments
- admin on Arithmetic Functions and Operators in Teradata SQL.
- jampa on Arithmetic Functions and Operators in Teradata SQL.
- Rahul Kale on Transaction Management
- Ravi prakash on Usage of Macro in Teradata
- bhanwar on How To Choose A Good Online Traffic School
Archives
- March 2011 (1)
- March 2010 (1)
- December 2009 (1)
- December 2007 (1)
- November 2007 (1)
- October 2007 (16)
- September 2007 (3)
- August 2007 (21)
- July 2007 (17)
- June 2007 (15)
- May 2007 (8)
- April 2007 (4)



