@pavan1987,

Sorry? Are you really sorry? When my last post in your last topic was:

Michel Cadot wrote on Mon, 07 February 2011 11:59

Michel Cadot wrote on Mon, 07 February 2011 10:37

For your previous topic:

Michel Cadot wrote on Fri, 04 February 2011 12:42

Michel Cadot wrote on Fri, 04 February 2011 12:33

...
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

I will add:
- Is "give a query" the only title you know? Can't you find a more neaningfull one?
- Post a working Test case: create table and insert statements along with the result you want with these data then we will be able work with your table and data.

Regards
Michel

I will add and do not use IM/SMS speak.

I really doubt you are sorry for anything.
It seems you really don't care about forum guide.

Regards
Michel