| help in a oracle sql command [message #311976] |
Mon, 07 April 2008 10:41  |
a_choch
Messages: 2
Registered: April 2008
Location: israel
|
Junior Member |
|
|
hello i have 2 commands and i cant figure out what is the command doing and what is the final answer.
i will thank very much for an answer
1.select (next_day(last_day(sysdate),'SAT') - next_day(last_day
(add_months(sysdate,-1)),'SAT')) / 7
from dual
2.Select max(a)
from t
where a < (select max(a) from t where a < (select max(a) from t))
|
|
|
|
|
|
| Re: help in a oracle sql command [message #312001 is a reply to message #311978] |
Mon, 07 April 2008 12:18  |
a_choch
Messages: 2
Registered: April 2008
Location: israel
|
Junior Member |
|
|
thanks.
and yes it is homework the thing with this commands that we just got this commands wich mens that i dont know what each thing gives you have any idea maybe??
tahnks again
asaf
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
