mssql..pls help me

misz_nz · #1 (**permalink**) 14-09-2006, 12:32 PM

akum..
sy nk tanye camne nk kuarkan tarikh terakhir dlm bulan yg kite dh select from db?cnth mcm statement kt bwh nih kn..

SELECT TARIKH FROM BILTUNAI WHERE (NOPENGEDAR = '12345') AND (YEAR(TARIKH) = '2006') AND (MONTH(TARIKH) = '07') ORDER BY TARIKH

so dia punye output:

1/7/2006
14/7/2006
23/7/2006

so skrg sy nk output yg dikuarkan ialah hari terakhir berdasarkan bulan yg kite select.cnth klu output utk kt atas tuh,sy nk dia display 31/7/2006.

ade sape2 leh tolong sy?thanks in advance..

chan0923 · #2 (**permalink**) 15-09-2006, 04:30 PM

Quote:

Originally Posted by misz_nz

SELECT TARIKH FROM BILTUNAI WHERE (NOPENGEDAR = '12345') AND (YEAR(TARIKH) = '2006') AND (MONTH(TARIKH) = '07') ORDER BY TARIKH

I suggest u use either a TOP or LIMIT function.

Code:

SELECT TOP 1 TARIKH FROM BILTUNAI WHERE 
(NOPENGEDAR = '12345') AND 
(YEAR(TARIKH) = '2006') AND 
(MONTH(TARIKH) = '07') 
ORDER BY TARIKH DESC

Sort the result in an descending order so that the largest date will be displayed on the top, then limit your result to 1.

The other way is

Code:

SELECT TARIKH FROM BILTUNAI WHERE 
(NOPENGEDAR = '12345') AND 
(YEAR(TARIKH) = '2006') AND 
(MONTH(TARIKH) = '07') 
ORDER BY TARIKH DESC LIMIT 1

Both query will return the correct result if I'm not mistaken. Hope this helps..

chan0923 · #3 (**permalink**) 15-09-2006, 04:37 PM

Did u mean when u select january 2006, the result will be the last date of january IN YOUR DATABASE RECORD, or you want EXACTLY the last day of January (31 Janury 2006) ?

If your case is the second, then you should use php date() function, instead of mysql select. The suggestion above only works if u want the last date in your database.

chan0923 · #4 (**permalink**) 15-09-2006, 04:38 PM

Also another things out of my curiosity, since your location is in bangi, I wonder if u're a UKM student ? Cause I'm also from UKM

misz_nz · #5 (**permalink**) 17-10-2006, 12:31 PM

thanks for the help..really appreciate it..

err i'm not ukm students..plus i'm not a student anymore..
i'm ex-unitenians..

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cheap Windows Host - ASP/ASP.net/PHP/MySQL/MSSQL (2 months free)	Katatonic	Web Hosting Offers	0	02-11-2006 01:58 PM
xHost SPECIAL => CFMX 7, ASP 2.0, ASP 1.1, PHP 4.0, PHP 5.0, MSSQL	xhosts	Web Hosting Offers	0	07-12-2005 11:07 PM
MYSQL & MSSQL : Can it run together	ajamz	Mamak Stall	8	04-07-2005 05:15 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)