Query help please

nbrege · #1 (**permalink**) 03-10-11, 13:50

Using the example of stock prices, suppose I have daily prices for a bunch of companys for the past year. Assuming I have name, date & price columns in my table, how would I get the change in price between any 2 dates for every company? So, for example, I would like to get the price change from yesterday to today (positive or negative) for each unique company. Thanks...

tonkuma · #2 (**permalink**) 03-10-11, 15:04

You have posted same question on Microsoft SQL Sever forum.
Need query help: price change

nbrege · #3 (**permalink**) 03-10-11, 15:43

yeah, I accidently posted to the wrong forum. But the query should be the same (or close), if you are able to help me...

ARWinner · #4 (**permalink**) 03-10-11, 15:48

What DB2 version and OS are you using? What have you tried so far?

Andy

nbrege · #5 (**permalink**) 03-10-11, 17:26

I'm actually using SQL Server, not DB2. I posted this in the wrong forum.
I haven't tried anything yet, because I dont have a clue how to tackle it. I'm sure it's simple, but my SQL skills aren't so good yet. Can you help me out?

Internet Services

Web Development

Digital Marketing

Consumer Tech