Wednesday, April 29, 2015

How to group by DESC order

You do group by, then you want to get the latest/smallest value. see below example

Table name `log`
idnamedate
1mia2015-04-10
2mia2015-04-03
3jame2015-04-11
4jame2015-04-13
5jame2015-04-01
6jame2015-04-15


select * from `log` group by name return below
idnamedate
1mia2015-04-10
2jame2015-04-11


select id,name,min(date) from `log` group by name return below
idnamedate
1mia2015-04-03
2jame2015-04-01


Another example: SELECT max(id) as id, asker FROM questions GROUP by asker

Tag: Give priority to ORDER BY over a GROUP BY in MySQL without subquery, SQL query ordering by alternating group ID

Friday, April 17, 2015

Pulau Perhentian

The island.. this year we plan so many thing with island, beach.. nice to have it and experience it. we bought the package at matta fair. cost about 800rm for 2, i cant recall the exact price.. normal me, i easily forget thing.. it cover the book transfer, hotel, 3 times meal a day and snorkeling package.

it was sudden plan as she want the beach in malaysia.. so i surprise by book the package.. in 2 week, we goin there.. i told her tht.. then can see her eyes sparkling.. hehe..

the journey begin travel from kl to kuala besut. since the bus station already move to TBS which in cheras, we have to travel by taxi to get there.. took about almost 1 hour and cost about 40RM.. the bus ticket easily can purchase online. u have many option for the bus. TBS was new for me, we have to search for the counter to exchange the ticket (not neccessacy), and checkout the terminal number. its cool place, more proper and convineet. not so much trouble. got food store summore, atm.

The journey to kuala besut is about 8 hour. we reach early around 5am. we have to wait until 9am for the jetty to open. the jetty is exaclty where the bus drop u. so not need to worry of getting lost. paid another 10rm for marin fees. then get to the boat. do take note where is ur resort, its either perhentian kecil or besar. i guess kecil is more happening, coz got local live there.. while besar, each resort are far from others.

Reach at the resort we upgrade our room, since at the matta fair they only give budget room which cant change. luckly the room avaiable, and we can switch.. good good.. the first day, nothing much to do, just walk along the beach.. the second day we go snorkeling!!! it was awesome.. dem pretty coral guys.. super dem a lot of fish.. big fish.. its the best.. cant ask for more.. like i dont wanna go home.. but at the resort itself, nothing much to do.. eat and eat.. sleep and sleep.. hehe.. well it a nice weekend.. dive and snorkeling are the best here.. see some photo and perhaps video we catch while snorkeling.. hehe.. yup first time try snap underwater photo..

next trip: cebu island (bantayan) and tioman for dive!!!

Mabul Island

wow.. how can i miss this one.. the awesome place ever!! how to get to mabul, get flight to tawau. then u have to travel by bus or taxi to semporna. that time i go alone, i have to cover a taxi from the airport to semporna about RM100/RM80. i dont remember exactly.. i bought a package from this guy http://scubajeffsipadan.com/.. its cover the boat transfer, meal, snorkeling package. they have many package u can choose.. dive, etc...

The island itself have many other option for the stay. u can look for uncle chang for exmple.. many more.i dont know much.. but i see a lot when I'm there. for scuba jeff, they have office at the land (semporna), contact them, they will give u the direction. they take u to the jetty to go to the island. I guess take about 45 min.. its so beautiful.. just take a look at the pic.. the best part, they don't have monsoon. so u can go there at anytime.



Tuesday, April 7, 2015

Lombok + Bali

Awesome awesome awesome awesome awesome.. no other word can describe.. how do we get 2 place at one time?? i dont know its consider as lucky or bad or coincidence.. whatever it is, Alhamdulillah.. Allah maha besar dan mengetahui.. Thanks to Allah for everything.. we save.. and for the experience..

What we plan actually to Lombok which is only 4 days 3 night holiday. the flight back to kl was cancel due to airport lombok closure. none flight could take off. the airasia provide us hotel and meal 3 times a day for 2 day. that just a bless.. Alhamdulillah..

(Tuesday) We already at the airport, check in, paid the airport tax and only wait for boarding.. first anouncement delay for 3 hour.. standard procedure i guess, coz other flight have declared cancel. after 3 hours, airasia and the airport staff told the flight could not take off. they will arrange a bus a take everyone to some hotel (bless). All of us in total 3 bus.. stay at i think 4 star hotel (probably tht the only hotel can accomudate us all - bless) at Mataram, which is about an hour from the airport. Arrive at the hotel welcome with welcome drink, everyone lineup to take the room key (bless). After done with the room, everyone had dinner at the hotel restaurant (provided by the hotel - bless). We got news said tomorow morning the bus will take us back to the airport for the flight back to kl. so next morning (Wednesday), everyone get ready with all bag waiting for the bus. a few hours waiting, another news came tht the bus only will come at 6pm.. Aih.. eveyone go back to room. me and syiema took this opportunity to go around mataram... enjoy ourselves another day at others country.. bless.. But again at 6pm they say the airport still close. we have to stay another night here. tomorow the bus will come. Tomorow early morning they said the bus and the AA crue will come here. (Thursday) Never expected they said, they cannot tell when exactly the flight can take off.. Now this is endless waiting, everyeone here decide we have to go to bali. otherwise we all will stuck here.. at 12 noon.. we all move together in total 3 bus, to senggigi to get a boat to bali.. which is everything we have to pay own (from the bus ride, boat and van at bali to airport).. the journey take almost 10 hour.. most of the time are waiting.. waiting for the bus, waiting for the boat, waiting for the van, traffic, etc.. only a few of us get the last flight from bali to kl. so me wait another day at bali. (Friday) since so many of us, we have to devide ourselves to get a seat flight to kl.. me get the noon flight. what the heck, if tht so, i just stay here over the weekend man, some how i would not get to the offce by the time i reach KL.. so the Holiday begin.. hehhehe.

Well let start with Lombok.. Lombok awesome.. prefect place for honeymoon.. hehe.. its really relaxing, im so definately gonna come again. our flight reach lombok at 7pm, we took a taxi to go to our shotstay at Rinjani Beach Eco Resort. took a bout 3 hour journey.. since it late we could not get boat to go to gili air directly. The next morning we took taxi to public jetty to go to gili air. we plan to use the public boat, which will cost cheaper 10krupiah something, but then i accidently pay for the private boat.. erk snap my head coz i didnt look closly for the thing i pay.. Nevermind.. with private boat the journey become faster and safer.. we stay at gili air.. at 7seas cottage.. nice room.. near to everywhere.. we go snorkeling.. we spent a day at gili tarawangan to see the pasar malam.. we rent a bicycle which i think is a must there... lepak at the beach, dining at the beach, mandi2.. best giler lah!!!..

And Bali.. it just nice having her with me.. the hotel we have very nice.. we rent a bike go around nusa dua, uluwatu, jimbaran. we stop to see the beach, people surfing.. we get sunburn a lot forget to wear proper cloth. huhuh.. next day we get the tour package see dance show, temple, mountain, many things.. shopping is a mustt... huhu... last day went back flight to kl smoothly.. Alhamdulillah.

*.. No pic since i broke the phone we use to snap all the pic.. dem!

Lombok + Bali

Rinjani Beach Eco Resort

Tawau + Kunak + Lahad Datu + Kota Kinabalu + Sandakan

This is her family day.. the holiday start the next day after my last day at my last company until a day before i start at new company. I have plan this offcoz.. i know when is my last day.. then i deal with the new company only after a week i'll join them.. brilliant.. i can have happly freely holiday.. once the date confirm, we get the flight and find rent car for the whole week there.. immediately reach tawau, we get the rent car when to her home which at kunak. the next day early morning i guess at 4pm we start the journey to KK.. its very long hour i guess we reach there at 5pm something. pheww.. we do stop at many placess actually.. we rent apartment. easy for us since we have many people. its holiday for her family, we try many thing.. before that we visit her relative at kampung air, which is fine family.. lovely, they have not seen each other many year.. they become closer after that.. bless.. she did many thing for her mom.. i learn that a lot how she treat her mother, which i dont do much for my mom.. i love you mom.. wish i can be good daughter for u.. done all stuff for her mom, now we do what we have plan for their family day.. we go snorkeling.. hehe.. then we go for seafood steamboat buffet... which her mom mistakenly thought the seafood as 'siput'.. hahah funny.. her mom force everyone to eat a lottttt before we go there, her mom tot we gonna eat siput only.. when we reach there, then only her mom understand, it was seafood.. rugi2 sbb sudah makan banyak..

then we also watch movie, experience for her 2 litle sister.. we wait until 1am to watch the movie.. it was late, coz that the only scary movie they have at the hour.. huhu really good experience.. then we also visit sabah museum.. Done with KK, we make a move to Sandakan.. Which quite long hour journey too.. we reach quite late, check in hotel. Only next morning we all visit her relative. spent time at sandakan was nice.. they got beach... nice.. spent a few day then went back to her hometown.. since her father not come with us, we have to get back early. she need to spend some hour with her dad too.. the holiday is awesome.. for us, her family, everyone.. its good to spent time with family.. i need tht too.. will plan holiday with my family too.. :)

USSSSSSSSSS

Hello!!
Yup Im blog.. now.. at office hour.. im so  dem bz nowdays.. New workplace are awesome.. so much programming.. that what i love to do. wait.. why im blog? yup, im doing programing and testing which require alot.. like very a lottttt of waiting.. dem! hate that.. ofcoz its part of job.. what to do

Alrite let continue with what i have left so many year...

Last year for her birthday celebration.. we go to Universal Studio Singapore!!!!!.. We drove From KL to Johor use PLUS highyway.. not remember how long it take and cost for the toll, sorry for that.. Johor we stay at zoom inn boutique hotel. Why we choose the hotel, because the place is really nearby to the agency where provide bus transfer to USS. Other than that u also can find Tune Hotel near by. Not to worry if u have other hotel, coz the place at the agency got space for park. The hotel that i have... mmm.. its too small for me.. i dont know bout others.. if u compare to tune hotel i think it almost the same size.. but the design are nice.. very cozy modern plus baliness.. i dont know bout the other type of room they have. the room i have is Deluxe Queen. we booked for 3 nite cost us RM338.88 from agoda. there is no restaurant nearby.. so its pretty hard.. we have to go out to find one. overall nothing much we do... the best bout the hotel they have Universal Studios Singapore (Daily Shuttle Service Available Through Reception).

The agency we have to go to USS i forgot the name.. it just nearby, walking distance from the hotel. the package with 5sgd coupun for the meal, uss ticket, transfer johor to singapore by bus. dont forget to bring ur passport. it very hasty to go down from the bus when u at the border.. very long queu.. but overall everything are nice.. the weather was raining but the time we reach USS, the sun comeout lovely..

picture will be add later (kalau rajin). I still have pending a few more story or event.. i really need to blog, coz i forgot thing easily. below are the list:-
1. Sabah The Family Day (8D7N)
2. Lombok+Bali (8D7N)
3. Pulau Perhentian (3D2N)