Function MAX [message #658051] |
Thu, 01 December 2016 09:40 |
|
tomekw
Messages: 5 Registered: December 2012
|
Junior Member |
|
|
Hello,
What to ask a question for this set to receive a record containing the value DATA for the maximum value of the field NUMBER?
Data Number
abc 1
abc 2
cde 3
vfr 4
bgt 5
abc 6
It is expected as a result of:
Data Number
abc 6
Is it to be done?
Regards
Tom
|
|
|
|
|
Re: Function MAX [message #658054 is a reply to message #658051] |
Thu, 01 December 2016 10:08 |
|
Michel Cadot
Messages: 68665 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
1/ We don't do homework.
2/ Post what you already tried.
3/ With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data.
4/ Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
5/ Align the columns in result.
6/ Also always post your Oracle version, with 4 decimals, as solution depends on it.
|
|
|