Home » RDBMS Server » Server Administration » Re: serial number in SQL reports
Re: serial number in SQL reports [message #373595] Wed, 25 April 2001 11:35
CHACKO
Messages: 11
Registered: March 2001
Junior Member
create sequence s1
start with 1
increment by 1;

select k.*,s1.nextval from table_name k;

Report message to a moderator

Previous Topic: Re: serial number in SQL reports
Next Topic: Re: serial number in SQL reports
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 10:31:15 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.