Google Quick Search Box for Windows

To install:

1. Download it! (Click here)
2. Open up Command Prompt (Win+R and type 'cmd' and press Enter)
3. Navigate in Command Prompt to where the file is saved, e.g., 'CD C:/Users/user/Downloads'
4. Copy and paste: googlequicksearchboxsetup.exe /install /bundle=tbie /global /brand=GGLL /hl=en
5. Press Return

Quick Search will be installed and you will then be able to configure it from the little button that appeared on your start menu.

To uninstall: 

1. Open a command prompt
2. Copy and paste:googlequicksearchboxsetup.exe /uninstall /bundle=tbie /global
3. Press Return

=================================================
Thanks to JAMES DOC "Christian · Blogger · Web Developer · Geek"

The SQL Distinct Key Word

This solution is for returning one record per user with either a min or max value in one of the record's fields.

stackoverflow has discussions/solutions for this topic listed under: sql group-by greatest-n-per-group

---------------------------------------------------------------

SELECT DISTINCT ON (P.ID) PR.PRACTICENAME AS "Practice", P.FIRSTNAME AS "First Name", P.MIDDLENAME AS "Middle Name", P.LASTNAME AS "Last Name", A.DATE::date AS "Last Appointment Date"

FROM PEOPLE AS P

JOIN CLIENT C ON C.ID = P.CLIENT_ID

JOIN PRACTICE PR ON PR.ID = P.PRACTICE_ID

JOIN APPOINTMENT A ON A.CLIENT_ID = C.ID

WHERE A.DATE IS NOT NULL

ORDER BY P.ID, A.DATE DESC

--------------------------------------------------------------- 

The beauty of this query is that is returns only the record for each client's latest appointment without  the use of complex sub-queries. Granted, the results may have to be further sorted, either using SQL or another tool, but it does return only one row per CLIENT and that row is for their LATEST appointment date.