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


ADVERTISEMENT

Minus One Date From Another

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

Now() Minus 20 Minutes?

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

Get Referer Minus The Querystring

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

Database Current Time -(minus) 3 Hours

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







Copyrights 2005-15 www.BigResource.com, All rights reserved