Home » SQL & PL/SQL » SQL & PL/SQL » Formulization at Query level
Formulization at Query level [message #293583] Mon, 14 January 2008 03:25 Go to next message
freakabhi
Messages: 74
Registered: November 2007
Location: mumbai
Member
Hi all.....

At the SQL level I need to make some formulization like

select a,b, count from xyz

now in here when record value for B matches with previous record value then Count should be 0 ....

is it possible at core SQL level....if yes please suggest ?


from
Freakabhi

Re: Formulization at Query level [message #293587 is a reply to message #293583] Mon, 14 January 2008 03:33 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LAG

Of course, you have to define "previous".

Regards
Micehl

[Updated on: Mon, 14 January 2008 03:34]

Report message to a moderator

Previous Topic: Join diffrent tables
Next Topic: Date Comparison and Manipulation
Goto Forum:
  


Current Time: Thu Dec 08 16:38:51 CST 2016

Total time taken to generate the page: 0.11639 seconds