I want to give condition in SQL Developer as follows:
- I want to select some data where status will be 'A', 'B', 'C' for particular CustomerID. CustomerID is not primary key.
- 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