Janardhan Reddy

Janardhan Reddy

  • NA
  • 3
  • 1.1k

select statement while loop

Oct 6 2014 2:15 PM

 Hi

Iam new for Sql I want fetch the data from DB below format using while loop .pls help me

 This is my DB data look like :
counternovaluedate
12006-Oct-14
13006-Oct-14
21006-Oct-14
28006-Oct-14
39006-Oct-14
41000006-Oct-14
520006-Oct-14
530006-Oct-14
72006-Oct-14
71006-Oct-14
 
I want out put like this.
 
counternovaluedate
15006-Oct-14
29006-Oct-14
39006-Oct-14
41000006-Oct-14
550006-Oct-14
73006-Oct-14
 

Answers (4)