Week should start with Monday by default or based on the input date parameters...

Can you pls give an example?

Lutz,Thanks for your reply.. But how do i get the count of records per week??

I want something like the below one...How do i include in my code to get this...

Thank you All...

Yeah, name column holds unique value.

Jeff, Only name column will not hold any NULL value....date may have...

Thanks!!

yes i did...but again ,have to define all columns in the where condition right??

and moreover,columns do not have same datatype..

Is there a way to check without specifying the column...

If you take the below example,

row 1 - fax column is null ,row 2&5 - e-mail and row 4 -mbl.

Here i want to eliminate all these rows and...

Thanks 🙂

Try using DISTINCT...

Using this command will eliminate the duplicate records.

Eg : Select distinct id,name from table1

Thanks