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
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: 25050
Registered: January 2009
Location: SoCal
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
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: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at ROW_NUMBER, RANK and DENSE_RANK functions.

Regards
Michel
Previous Topic: Object type Casting and %type (merged)
Next Topic: UPDATE vs DELETE...INSERT
Goto Forum:
  


Current Time: Sat Dec 10 01:04:40 CST 2016

Total time taken to generate the page: 0.05379 seconds