Hello world from cyberjaya.
This is my first posting from cyberjaya.
yes..it’s from cyberjaya,from my new company.Today is my second day here.
So stress, because there are many things to catch up in 1 week time.
Well,nothing much i want to say today.
err…do you guys know that we cannot do Select top 10 * from table_name
in ORACLE ?? instead, we have to do
select * from (select * from table_name) where rownum <= 10
If you know the easiest way to do “select top” in oracle,please let me know.
till then….adios..
p/s : adehh…takleh nak posting byk² skang nie.tunggu dah stabil sket kot baru leh berposting smula.
gerg,hang cyberjaya kat ner ek ? 
nuar,hang ape habaq ? bila start kejer baru ?
cypher,pelajaran camner ? (eheh..soklan skema)
lenlain….apa khabar ? dah ada azam baru ker ?
![[Ask]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/ask.png)
![[Bloglines]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/bloglines.png)
![[del.icio.us]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/delicious.png)
![[Digg]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/digg.png)
![[Furl]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/furl.png)
![[StumbleUpon]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/stumbleupon.png)
![[Technorati]](http://www.arejae.com/blog/wp-content/plugins/bookmarkify/technorati.png)
If you're new here, you may want to subscribe to my RSS feed or get my latest post directly in your mailbox. Thanks for visiting !
aku kat bangunan FSBM tu yg dekat bomba .. ko kije company apa nih cuba citer sikit .. nak berahsia gak tu
bagi soklan ko tu agak nya boleh guna limit kot top tu tuk mssql jek kalau tak silap aku
oopss silap tu .. tak boleh pakai limir rupanya
cuba ko usha sini http://dotnet.org.za/thea/archive/2005/02/22/14715.aspx
ok thanks gerg,leh pakai camnie jer.
Select * from table_name WHERE ROWNUM < = 10dah reduce sket time nak tulis query tuh.
tocey gerg.
ehehe,aku dekat area area traffic light kat MSC head tuh. nanti ler aku cakap ngan hang company apa.nanti lunch sama² . :)>-
tambahan dari query kat atas. (rujuk pada link yg gerg bagi)
kalau nak select top and order by skali kena pakai camnie lak
SELECT product, descr, email
FROM (select product, descr, email from products order by product )
WHERE ROWNUM < = 10
camtuh plak ek.