Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Include Numeric Values in SQL statements
How To Include Numeric Values in SQL statements? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples:
SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -6.34 SELECT -32032.6809e+10 FROM DUAL; -- A floating-point value -3.20326809e+014
2007-05-11, 5306👍, 0💬
Popular Posts:
What is the difference between Authentication and authorization? This can be a tricky question. Thes...
What is the quickest sorting method to use? The answer depends on what you mean by quickest. For mos...
Which bit wise operator is suitable for turning on a particular bit in a number? The bitwise OR oper...
How To Give a User Read-Only Access to a Database? - MySQL FAQs - Managing User Accounts and Access ...
What's the output of the following program? And why? #include main() { typedef union { int a; char b...