Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-06-2007
01:15 PM

06-06-2007
01:15 PM

I have some basic SQL questions, please pardon me for my lack of knowledge.

<> When do we use FLOAT or DECIMAL in SQL, what's the criteria?

<> Is how to define DECIMAL/FLOAT is a standard in all the SQL or different in Teradata SQL.

<> What does it mean when we say DECIMAL (5,5) OR DECIMAL (6,5)

does it mean precision can be any number between 1 thru 9 and precision length would be equal to the number on left and scale's length would be limited to 5 numbers after decimal points?

<> How to define DECIMAL value ".00000" ? how to define ".00000" in float?

<> How is FLOAT represented in Teradata SQL? FLOAT (3,4)???

<> when to use: GROUP BY, HAVING, ORDERY clause?

I would appreciate anyone's explanation on it.

<> When do we use FLOAT or DECIMAL in SQL, what's the criteria?

<> Is how to define DECIMAL/FLOAT is a standard in all the SQL or different in Teradata SQL.

<> What does it mean when we say DECIMAL (5,5) OR DECIMAL (6,5)

does it mean precision can be any number between 1 thru 9 and precision length would be equal to the number on left and scale's length would be limited to 5 numbers after decimal points?

<> How to define DECIMAL value ".00000" ? how to define ".00000" in float?

<> How is FLOAT represented in Teradata SQL? FLOAT (3,4)???

<> when to use: GROUP BY, HAVING, ORDERY clause?

I would appreciate anyone's explanation on it.

1 REPLY

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-07-2007
03:04 PM

06-07-2007
03:04 PM

Check this out:

http://websiteowner.info/books/databases/dummiessql.asp

http://websiteowner.info/books/databases/dummiessql.asp