Viewing 15 posts - 1 through 15 (of 133 total)
Of those a really good article because people are not aware of problems with statistics. The classic book on this is "how to lie with statistics." By Darrell Huff. It...
January 10, 2017 at 2:24 pm
Of course, JC would use the INFORMATION_SCHEMA views, because they're part of the SQL standard. However, my knowledge is not enough to know how to identify the constraint...
January 9, 2017 at 10:33 am
I notice that you avoided the question of how to produce a report of sports that do not currently have any participants.
Here is a little different way of doing...
January 9, 2017 at 10:29 am
I have to write a query that lists orders and partitions them by customer id# and displays the something_date, customer_id, generic_name, order_amount and something_count on each line (sic).
January 7, 2017 at 6:37 pm
I see absolutely no benefit to having this as a check constraint rather than as a foreign key constraint.
The check constraint can be used by the optimizer immediately; it is...
January 7, 2017 at 5:08 pm
Having a new sport shouldn't require a DDL change. Getting a list of available sports shouldn't need to remove duplicates.
I would make the argument that the list of available...
January 5, 2017 at 3:10 pm
I have been teaching SQL for over 30 years. In that time I found that if you do not give a newbie all the information that they need, they tend...
January 5, 2017 at 11:43 am
You are right. Let us post a correction i just got in a hurry. My bad.
CREATE TABLE Players
(player_id CHAR(5) NOT NULL PRIMARY KEY,
first_name VARCHAR(10) NOT NULL,
last_name VARCHAR(10) NOT NULL);
January 5, 2017 at 11:27 am
>> Below is the table and results I am looking for......i am an SQL newbie. <<
please read the forum rules about how to do a posting. Your narrative should have...
January 4, 2017 at 9:45 am
You really need to get a book on basic RDBMS because your approach is completely wrong. You also fail to post DDL; please read the forum rules and learn about...
January 4, 2017 at 8:38 am
>> I'm pretty new to this and am in need of some help writing a query. I'll try to explain. <<
Do not try to explain things by telling us a...
December 28, 2016 at 11:43 am
I have to group these records [sic: rows are not records] together - the above data creates two groups :
Group 1 --> ProdA, ProdB, ProdC
Group 2 --> ProdD, ProdE...
December 23, 2016 at 8:50 am
those were slanders aimed at me; I might do "ignorant"when I am talking to someone, but I will back it up with evidence. I believe I can present evidence that...
December 19, 2016 at 10:25 pm
, I (and many others) get really pissed off when people make illiterate/ignorant claims like "an order clause converts a set into a cursor".
Illiterate and ignorant? Which one...
December 18, 2016 at 12:16 pm
This is usually not a good design. For the painful details read this:
December 14, 2016 at 1:27 pm