Sheila wants to determine salaries rounded to the nearest thousandth. She then wants to compare those values to the values of salaries truncated to the thousandth position. She has looked up the syntax for the numeric functions and created a small sheet about them:
Help Sheila find this information.
Using Numeric Functions
Sunday, January 31, 2010
by
Abdul Majid Niazi
·
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(53)
-
▼
January
(52)
- Creating Groups: Part 1
- Using the Grouping Functions
- Group Functions: Part 2
- Group Functions: Part 1
- Group Functions: Part 1
- Working with Groups of Data
- Using the NVL Function
- Using the NVL Function
- Formatting Dates
- Formatting Dates
- Using Date Functions
- Date Functions: Part 2
- Date Functions: Part 1
- Using Numeric Functions
- Number Functions
- Using Character Functions
- Character Functions: Part 2
- Character Functions: Part 1
- Using Functions to Customize Reports
- Joining Multiple Tables
- Joining Multiple Tables
- Applying Additional Conditions to a Join
- Applying Additional Conditions to a Join
- Joining Tables and Identifying Columns
- Joining Tables and Identifying Columns
- Simple Joins
- Simple Joins
- Joining Tables
- Retrieving Rows
- Retrieving Rows
- Retrieving Columns
- Retrieving Columns
- Writing a Basic Query
- Writing a Basic Query
- Building Queries
- Building Queries: Part 2
- Building Queries
- Accessing Data
- Removing a Copy of a Table
- Removing Tables
- Implementing Business Rules
- Creating Constraints
- Identifying Constraints
- Managing Constraints
- Adding a New Column
- Modifying Tables
- Creating a Copy of a Table
- Creating Tables Using SQL
- Creating Tables by Using the Object Browser
- Creating Tables
- Working with Database Objects
- Relational data base
-
▼
January
(52)
0 comments:
Post a Comment