Article Discussion: How to Retrieve Data from a Single Table

In this chapter, "How to Retrieve Data from a Single Table", you’ll learn how to code SELECT statements that retrieve data from a single table. You should realize, though, that the skills covered here are the essential ones that apply to any SELECT statement you code…no matter how many tables it operates on, no matter how complex the retrieval. So you’ll want to be sure you have a good understanding of the material in this chapter before you go on to the chapters that follow. This comes from Chapter 3 by Bryan Syverson in Murach's SQL for SQL Server (Murach, ISBN 1-890774-16-2, 2002).


Read the full article here: How to Retrieve Data from a Single Table

Hi, I've just been reading through the How to Retrieve Data from a Single Table and was wondering if someone could help with the following as I cant seem to find the answer to what is probably an easy question for the experts. I'm a Visual FoxPro 6 user and use the following code to almost accomplish what I'm after

SELECT * FROM mytabletemp INTO TABLE LISTINGS GROUP BY TITLE
This works perfectly and removes any duplicate entries with the same TITLE
My problem (and yes it's been a problem!) is that I have four possible country of ORIGIN codes such EEC - USA - CAN - DOM

What I'm trying to do is search out any duplicate TITLES as shown below but keep the USA ones
Example:

ADAMS, BRYAN - BEST OF - EEC
ADAMS, BRYAN - BEST OF - USA
ADAMS, BRYAN - BEST OF - CAN
ADAMS, BRYAN - BEST OF - DOM

How do I remove three of the above just keeping the USA title?
I would be more than grateful if anyone can suggest the answer
Kindest regards
Lee