Home » SQL & PL/SQL » SQL & PL/SQL » ORACLE KEEP FIRST to MS SQL (Oracle/MS Sql)
ORACLE KEEP FIRST to MS SQL [message #441851] Wed, 03 February 2010 06:50 Go to next message
abulloch
Messages: 1
Registered: February 2010
Location: South Africa
Junior Member
Hi .

I am currently converting some Oracle SQL to MS Sql and have a problem with the following:
What / how can I replace the KEEP section :

MIN (COALESCE (A5.LINE_NUMBER,
A6.LINE_NUMBER,
A7.LINE_NUMBER,
A8.LINE_NUMBER))

)KEEP (DENSE_RANK FIRST ORDER BY ISNULL(A10.T$SUBL,9) * 1000
+ ISNULL (A11.T$SUBL, 9) * 10
+ ISNULL (A12.T$SUBL, 9) ASC) LINE_NUMBER,

Regards

Allan
Re: ORACLE KEEP FIRST to MS SQL [message #441853 is a reply to message #441851] Wed, 03 February 2010 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
I am currently converting some Oracle SQL to MS Sql

You will better get an answer in a MS/SQL forum without forgetting to clearly explain the part of Oracle syntax that is not in MS/SQL one.

Regards
Michel
Re: ORACLE KEEP FIRST to MS SQL [message #441898 is a reply to message #441851] Wed, 03 February 2010 14:09 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
You will also find that there are MANY things that can be done in oracle that are not available in other databases. Just curious, why are you converting from a first class database to an inferior one.
Re: ORACLE KEEP FIRST to MS SQL [message #441908 is a reply to message #441898] Wed, 03 February 2010 18:00 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The most common reason is cost.
Previous Topic: how to achieve utl_udp
Next Topic: ORA-06502: Host bind array to small (web service callout)
Goto Forum:
  


Current Time: Tue Feb 18 01:42:54 CST 2025