Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: can someone show some oracle sql stmt, I want to compare that with MYSQL in linux rh 9.0
"developer" <developer_at_earth.com> wrote:
> can someone show some oracle sql stmt, I want to compare that with MYSQL
> in linux?
> thanks!
select smp.id,
corr(
(select val from a where a.expID=exp.id and a.smpID=2), (select val from a where a.expID=exp.id and a.smpID=smp.id))
You're welcome.
Xho
-- -------------------- http://NewsReader.Com/ -------------------- Usenet Newsgroup Service New Rate! $9.95/Month 50GBReceived on Mon Aug 11 2003 - 13:37:15 CDT
![]() |
![]() |