Back to HomePage
The following is a list of SQL scripts that might be useful
to perform common tasks. I will be adding more eventually.
If you can think of any code that can be helpful or if you want to
submit your own code, please mail me with the details. And I'll
include your code along with your name.
Script to retrieve rows between an initial and final range from a table
Script to retrieve the top N salaries
Script to find indexes for a given table
Script to find constraints for a given table
Script to find locked objects
Script to find duplicate rows in a table
Script to delete duplicate rows from a table
Back to HomePage