it is a very silly question but I had a doubt in sql commands i know some commands like SELCET,INSERT etc.can it possible to do calculations like additions,multiplications etc.in the sql statement which can be executed and updated in the database.for example column1+column2=column3. thanks for your response in advance.
Pretty much any intermediate to advanced SQL book.
The basic insert from a select or subquery type of stuff should be coverd in any decent SQL book. I use Oracle, so I got a lot of specifics for Oracle's SQL dialect from the Oracle publications and docs. MS-SQL server has similar stuff as does the rest of the production ready SQL DB's.