Oracel SQL need to apply group by for header row to add

Question

0.00/5 (No votes)

See more:

5111 XJL PORTFOLIO V91103 2016 29-Feb-2016 29-Feb-2016 VIP 150 150 J0022 1111111111 0
5111 XJL PORTFOLIO V94268 2016 03-Feb-2016 05-Feb-2016 Individual 150 150 J0022 1111111111 0
9700 XF 35t Premium RWD Y06592 2016 17-Feb-2016 22-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9700 XF 35t Premium RWD Y14489 2016 15-Feb-2016 17-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
5130 XJL Supercharged V95451 2016 29-Feb-2016 29-Feb-2016 Corporate 150 150 J0022 1111111111 0
9710 XF 35t Prestige RWD Y10264 2016 23-Feb-2016 23-Feb-2016 Individual 150 150 J0022 1111111111 0
9710 XF 35t Prestige RWD Y07909 2016 29-Feb-2016 29-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9710 XF 35t Prestige RWD Y10851 2016 29-Feb-2016 29-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9710 XF 35t Prestige RWD Y06630 2016 29-Feb-2016 29-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9720 XF 35t R Sport RWD Y08105 2016 29-Feb-2016 29-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9720 XF 35t R Sport RWD Y10802 2016 29-Feb-2016 29-Feb-2016 LOANER FLEET 150 150 J0022 1111111111 0
9720 XF 35t R Sport RWD Y04770 2016 29-Feb-2016 29-Feb-2016 VIP 150 150 J0022 1111111111 0

above is my output in the first column ill get a code with same value and 2nd column will have same brand name i need this should be
grouped with a header on top with some different value inserted in first column and a header name in 2nd column with same value in the 2nd column
remaining all as null

i need some what like this

1 XJL PORTFOLIO Null Null null
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
2 XF 35t Premium RWD Null Null Null
9700 XF 35t Premium RWD Y06592 2016 29-Feb-2016
9700 XF 35t Premium RWD Y06592 2016 29-Feb-2016

What I have tried:

above is my output in the first column ill get a code with same value and 2nd column will have same brand name i need this should be
grouped with a header on top with some different value inserted in first column and a header name in 2nd column with same value in the 2nd column
remaining all as null

i need some what like this

1 XJL PORTFOLIO Null Null null
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
5111 XJL PORTFOLIO V91103 2016 29-Feb-2016
2 XF 35t Premium RWD Null Null Null
9700 XF 35t Premium RWD Y06592 2016 29-Feb-2016
9700 XF 35t Premium RWD Y06592 2016 29-Feb-2016

Posted 26-Oct-16 0:11am

Member 10902837

Updated 26-Oct-16 0:14am

Nelek

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)