Write an SQL query to fetch only new and changed rows?

Note :This is the question asked by a visitor Sravan. I am posting this in proper forum.