Home » SQL & PL/SQL » SQL & PL/SQL » Generating sequence numbers for Duplicate records
Generating sequence numbers for Duplicate records [message #326525] Wed, 11 June 2008 22:08 Go to next message
pyaranoid
Messages: 5
Registered: June 2006
Karma: 0
Junior Member
Hi,

Could any one of you explain me how to generate sequence numbers for duplicate records?I need this one in SQL code only.

Thanks in advance

Sue
Re: Generating sequence numbers for Duplicate records [message #326527 is a reply to message #326525] Wed, 11 June 2008 22:12 Go to previous messageGo to next message
BlackSwan
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guidelines as stated in URL above

I don't understand the inputs, requirements, or expected results.
Re: Generating sequence numbers for Duplicate records [message #326549 is a reply to message #326525] Wed, 11 June 2008 23:30 Go to previous messageGo to next message
oraclestudent
Messages: 8
Registered: June 2008
Location: hyderbad
Karma: 0
Junior Member
Sue,

can you pls provide us what you are expecting with sample data or example.

thanks
Re: Generating sequence numbers for Duplicate records [message #326572 is a reply to message #326525] Thu, 12 June 2008 00:50 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Have a look at ROW_NUMBER, RANK and DENSE_RANK functions.

Regards
Michel
Previous Topic: SQL Query re-write assistance requested
Next Topic: can we use update and select command in single query.
Goto Forum:
  


Current Time: Tue Aug 22 13:48:13 CDT 2017

Total time taken to generate the page: 0.12429 seconds