January 5, 2010

When you use the comparison operators in SQL with the Where clause, you can remove the columns with null values. If you need the values with null too, then you

Learn how to get row number in SQL. The 1998 tip “Displaying the Row Number in a SELECT Query” tells you to create a temp table to display the row