Here are some examples of the difference between consuming and creating:

• Refreshing your email inbox and reading the messages that you receive (consume) versus reaching out and getting in touch with people (create)
• Watching entertaining videos (consume) versus brainstorming ideas for a project you’re interested in (create)
• Listening to tutorials and reading guides (consume) versus taking notes and putting them into practice (create)

A Most Important Task (MIT) is a critical task that will create the most significant results. Every day, create a list of two or three M.I.T.s, and focus on getting them done as soon as possible. Keep this list separate from your general to-do list. - The Personal MBA

You didn't say what version you were using, but in SQL 2005 and above, you can use a common table expression with the OVER Clause. It goes a little something like this:

WITH cte AS (
SELECT[foo], [bar],
row_number() OVER(PARTITION BY foo, bar ORDER BY baz) AS [rn]
FROM TABLE
)
DELETE cte WHERE [rn] > 1