FREE Subscription to Dr. Dobb’s Digest: Same Great Content, New Digital Edition
Site Archive (Complete)
Architecture & Design
Email
Print
Reprint

add to:
Del.icio.us
Digg
Google
Furl
Slashdot
Y! MyWeb
Blink
January 01, 2002

PostgreSQL vs. MySQL (Web Techniques, Sep 2001)

(Page 5 of 8)
# Create a temporary table and put the highest salary
# into it.
#
CREATE TEMPORARY TABLE max_salary
SELECT MAX(salary.salary) as max_salary FROM salary;

# Join the employee and salary table to the # max_salary table to get the names of the # employees with the highest salary. # SELECT employee_name FROM employee, salary, max_salary WHERE employee.employee_id = salary.employee_id AND salary = max_salary

Previous Page | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 Next Page
TOP 5 ARTICLES
No Top Articles.



MICROSITES
FEATURED TOPIC

ADDITIONAL TOPICS

INFO-LINK