lundi 2 mars 2015

If else in Sql Developer

I want to give condition in SQL Developer as follows:



  1. I want to select some data where status will be 'A', 'B', 'C' for particular CustomerID. CustomerID is not primary key.

  2. If CutomerId has status as 'A' then, in next row, if same CustomerId has status 'B' then I want to select that CustomerID.


Aucun commentaire:

Enregistrer un commentaire