Home » SQL & PL/SQL » SQL & PL/SQL » The optimal approach to this search
The optimal approach to this search [message #625764] Tue, 14 October 2014 01:38 Go to next message
hahaie
Messages: 194
Registered: May 2014
Senior Member
hi all,
this select return name and age of oldest person.
but This method is not desirable.
Some believe that Use rownum When data is read from the database, Malfunctioning.
Correct method for displaying oldest person you know?

Report message to a moderator

Re: The optimal approach to this search [message #625765 is a reply to message #625764] Tue, 14 October 2014 01:43 Go to previous messageGo to next message
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
Senior Member
You appear to be a in a country where use of Oracle products is illegal.

--update:
Removed explicit mention of the country concerned. JW.

[Updated on: Sun, 19 October 2014 04:32]

Report message to a moderator

Re: The optimal approach to this search [message #625768 is a reply to message #625764] Tue, 14 October 2014 02:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

But you can read our wiki: How does one select the TOP N rows from a table?

Report message to a moderator

Re: The optimal approach to this search [message #625771 is a reply to message #625768] Tue, 14 October 2014 02:26 Go to previous message
hahaie
Messages: 194
Registered: May 2014
Senior Member
Thank you so much

Report message to a moderator

Previous Topic: Select distinct rows before special character
Next Topic: Convert a string to a date using TO_DATE Function in after insert trigger?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 10:42:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.