vishnu7185

 Profile Answers by vishnu7185 

• Aug 1st, 2008

 

Can be done Using Cursors

DECLARE  @product int

DECLARE crsr CURSOR FOR (all values)

SELECT @product = @product * @crsr_value

fetch CURSOR

samala_naresh

 Profile Answers by samala_naresh 

• Aug 7th, 2008

 

declare @var int
select @var = 1
update

set @var = @var*< colname >
select @var

samblag

 Profile Answers by samblag 

• Aug 4th, 2010

 

Look and learn

Select exp(Sum(log(<column name>))) from <table name>

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

- Reason - Answer is wrong Spelling Mistakes Duplicate Answer Inappropriate Answer Other

 

Related Answered Questions

•   How to convert single row to two columns
•   Over vs runs -- same sequence number for each group
•   Load a file in Oracle in chunks of 100 MB files
•   How to add header and trailer in a file?
•   How to validate a column, which takes only number and character value?
•   Worksoft certify
•   Floor casting
•   Load different data files in single target table
•   Dynamic target creation using source data
•   Data from 1 column to be separated in multiple columns

 

Related Open Questions

•   3 phase
•   Rdbms
•   Convert any two numbers into words and perform arithmetic operation
•   Concatenate two circularly single linked list into one circularly linked list
•   Create delta file in jcl
•   Update a table using multiple join conditions
•    Add/modify column changes in facts and dimensions
•   Find destination field
•   Import complete coloumn values to excel
•   Click on previous object under a web element

 

 

Latest News

 

It looks like you are using an AD Blocker!

 

 

Please Turn OFF your ad blocker

- OR -

LOGIN to continue using GeekInterview website.

 

 

 

Disable
Ad Blocker

 

Learn More

Login
GeekInterview

 

Login

Create your
GeekInterview account

 

Signup

Continue Reading after Disabling

 

Refresh