I want to use HASHBYTES()
But i dont know How to get back value passed to HASHBYTES...
I have a query to select all the colors not shipped by supplier S1
Query:
select distinct parts.color as part_color
from parts
where parts.partno
in (select parts.partno
from shipments,parts,suppliers
where parts.partno=shipments.partno
and suppliers.supplierno=shipments.supplierno
and sup...
I’m going to buck the pervasive mentality here and ask the question:
Why shouldn’t dba.stackexchange.com include basic SQL questions?
Previous related discussions:
How do we define a question as being "too basic"? Where do we draw the line?
Beginner's questions (convert Access queries and ...
I'm trying to count old records, why postgres gives 1160 even through I set some limit, LIMIT 1 in this case:
db=# SELECT COUNT(*) FROM data WHERE datetime < '2015-09-23 00:00:00' LIMIT 1;
count
-------
1160
(1 row)
Expected value 1 or 0, but it give 1160. Why?
The Birthday Paradox, or why PRNGs produce duplicates more often than you might think.
There are a couple of issues at play in the OP's problem. One is the birthday paradox as mentioned above and the second is the nature of what you are generating, which does not inherently guarantee that a giv...
