Sql Minus
anyone familiar with sql minus statement?coz when i use
Quote: sql="select * from test minus select * from testing"
it suppose to see only the rows that don't match in both queries.but when i execute this statement it giv me also rows which hav match in both queries.that is i hav 10 row n col.then after execute it show me again 10 row n col
View Replies
Is there a way if someone enters a date, like 02/02/04, and have that date subtract from 02/04/04; so the number 2 is returned, and if you wanted to see if 02/05/04 is greater than 02/04/04 returns true?
View Replies
View Related
I wish to count the lastLoginDateTime field that has any date and time in it that is within 20 minutes of now(). Code:
View Replies
View Related
I need to redirect after processing to the previous script (referer). However I dont wish to redirect including the querystring. Just the referer's script name.
View Replies
View Related
Ive got some code on my site that shows how current the database is. Basically it looks at fixed text file that I am basing the database on, checks to see iwhen it was created, then displays the time.
My webserver must be on the East Coast and I am on the West Coast, so the time the stamped file time is 3 hours ahead. Code:
View Replies
View Related