group by problem

Hi,
I have a simple question to ask(I think). I have a database which has two
columns
Number1, Number2
13044 12789
13044 18872
13044 22767
Now I need a query that gives me one row from the table. Like this:
Column1 Column2 Column3 column4
13044 12789 18872 22767
Can you help me? Thanks!select top 1 * from <table>
or
set rowcount 1
select * from <table>
--
Aleksandar Grbic
MCDBA
"jesper" wrote:
> Hi,
> I have a simple question to ask(I think). I have a database which has two
> columns
> Number1, Number2
> 13044 12789
> 13044 18872
> 13044 22767
> Now I need a query that gives me one row from the table. Like this:
> Column1 Column2 Column3 column4
> 13044 12789 18872 22767
> Can you help me? Thanks!
>|||wrong answer
--
"Aleksandar Grbic" wrote:
> select top 1 * from <table>
> or
> set rowcount 1
> select * from <table>
> --
> Aleksandar Grbic
> MCDBA
>
> "jesper" wrote:
> > Hi,
> > I have a simple question to ask(I think). I have a database which has two
> > columns
> > Number1, Number2
> > 13044 12789
> > 13044 18872
> > 13044 22767
> >
> > Now I need a query that gives me one row from the table. Like this:
> >
> > Column1 Column2 Column3 column4
> > 13044 12789 18872 22767
> >
> > Can you help me? Thanks!
> >|||Hello,
sorry my mistake, it wasn't so simple as I asked. The table has over 5000
rows and it looks like:
13044 12789
13044 18872
13044 22767
12004 45333
12004
12004 43992
and the result should be 13044 12789 18872 22767
12004 45333 43992
etc.
"Aleksandar Grbic" wrote:
> select top 1 * from <table>
> or
> set rowcount 1
> select * from <table>
> --
> Aleksandar Grbic
> MCDBA
>
> "jesper" wrote:
> > Hi,
> > I have a simple question to ask(I think). I have a database which has two
> > columns
> > Number1, Number2
> > 13044 12789
> > 13044 18872
> > 13044 22767
> >
> > Now I need a query that gives me one row from the table. Like this:
> >
> > Column1 Column2 Column3 column4
> > 13044 12789 18872 22767
> >
> > Can you help me? Thanks!
> >|||"jesper" wrote:
> Hello,
> sorry my mistake, it wasn't so simple as I asked. The table has over 5000
> rows and it looks like:
> 13044 12789
> 13044 18872
> 13044 22767
> 12004 45333
> 12004
> 12004 43992
> and the result should be 13044 12789 18872 22767
> 12004 45333 43992
> etc.
> "Aleksandar Grbic" wrote:
> > select top 1 * from <table>
> > or
> >
> > set rowcount 1
> > select * from <table>
> > --
> > Aleksandar Grbic
> > MCDBA
> >
> >
> > "jesper" wrote:
> >
> > > Hi,
> > > I have a simple question to ask(I think). I have a database which has two
> > > columns
> > > Number1, Number2
> > > 13044 12789
> > > 13044 18872
> > > 13044 22767
> > >
> > > Now I need a query that gives me one row from the table. Like this:
> > >
> > > Column1 Column2 Column3 column4
> > > 13044 12789 18872 22767
> > >
> > > Can you help me? Thanks!
> > >
Hi,
It looks to me like you are trying to "pivot" your result set. This is also
known as a CROSSTAB query.
Please see the link below, it may be something you can modify to suit your
purposes.
http://www.stephenforte.net/owdasblog/PermaLink.aspx?guid=2b0532fc-4318-4ac0-a405-15d6d813eeb8
Cheers,
Ian