<[EMAIL PROTECTED]>
To:
Sent: Thursday, August 25, 2005 5:23 PM
Subject: Re: create "serial number" by select
On Thu, 25 Aug 2005, Pooly wrote:
Why not adding an auto_increment column to your data ?
2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>:
I can't build &
ware) :(
Only 1 select allowed! Because it is the reporting system...
1 output is 1 select!
Best Regards!
Zoli
- Original Message -
From: "Jason Pyeron" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 25, 2005 5:23 PM
Subject: Re: create "serial number" by
To:
Sent: Thursday, August 25, 2005 5:23 PM
Subject: Re: create "serial number" by select
On Thu, 25 Aug 2005, Pooly wrote:
Why not adding an auto_increment column to your data ?
2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>:
I can't build "serial number" in
On Thu, 25 Aug 2005, Pooly wrote:
Why not adding an auto_increment column to your data ?
2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>:
I can't build "serial number" in table1!
Because he is not allowe to modify the table, pick any reason.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hi,
Why not adding an auto_increment column to your data ?
2005/8/25, Gyurasits Zoltán <[EMAIL PROTECTED]>:
> Hello All!
>
>
> I have a little problem. I can't do "serial number" in result of select.
>
> Example:
>
> TABLE1
>
> value
> --
> res1
> res2
> res3
>
>
> SELECT (
Gyurasits Zoltán wrote:
Hello All!
I have a little problem. I can't do "serial number" in result of select.
I guess you want to display a sequential number for each row in the result.
First of all a warning: if there is no ORDER BY in the query there is no
specific order in which the result
Hello All!
I have a little problem. I can't do "serial number" in result of select.
Example:
TABLE1
value
--
res1
res2
res3
SELECT (??), value FROM table1 ...
1res1
2res2
3 ...
.
.
I can't build "serial number" in table1!
Thans!
Best Regards!
Zoli