Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Calculate Expressions with SQL Statements
How To Calculate Expressions with SQL Statements? - MySQL FAQs - Introduction to SQL Basics
✍: FYIcenter.com
There is no special SQL statements to calculate expressions. But you can use the "SELECT expression FROM DUAL" statement return the calculated value of an expression. "DUAL" is a dummy table in the server. The tutorial exercise below shows you some good examples:
SELECT 'Hello world!' FROM DUAL; Hello world! SELECT (1+2)*3/4 FROM DUAL; 2.2500 SELECT TRUE FROM DUAL; 1 SELECT TRUE AND FALSE FROM DUAL; 0 SELECT TIME(SYSDATE()) FROM DUAL; 21:30:26
2016-11-09, 7784👍, 1💬
Popular Posts:
Can you please post OpenLink Endur related FAQ's,tutorials,document s.Thanks
What will be printed as the result of the operation below: main() { int x=20,y=35; x=y++ + x++; y= +...
.NET INTERVIEW QUESTIONS - Did VB6 support multi-threading ? While VB6 supports multiple single-thre...
What will be printed as the resultof the operation below: int x; int modifyvalue() { return(x+=10); ...
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...