Clustered Indexes

2004-01-02 Thread Casey Sheridan
In MS SQL Server 2000, it is possible to create what MS refers to as "clustered indexes." You can have only one clustered index per table, because the index is created by sorting the entire table by the row that is to be the clustered index. If you have a table with a row called "ZIPCODE", for ex

writing queries to get distinct results

2004-03-18 Thread Casey Sheridan
same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL