Hi Guys,
Need help in writing a SQL query in Ms Access with respect to ranked comments:
Ranked Comments:
Comments Rank
FullName_Tel_Dup 1
FirstName_LastName_Tel_Dup 2
FullName_Fax_Dup 3
FirstName_LastName_Fax_Dup 4
Source Table Data:
ID Comments
1 FullName_Tel_Dup
2 FirstName_LastName_Tel_Dup
3 FirstName_LastName_Tel_Dup
1 FirstName_LastName_Fax_Dup
2 FullName_Fax_Dup
3 FirstName_LastName_Fax_Dup
1 FirstName_LastName_Tel_Dup
2 FirstName_LastName_Fax_Dup
3 FullName_Tel_Dup
And below should be the required output:
ID Comments
1 FullName_Tel_Dup
2 FirstName_LastName_Tel_Dup
3 FullName_Tel_Dup
Request your help for the above requirement and let me know if any further information is required.
Thanks and regards,
Rakesh
Need help in writing a SQL query in Ms Access with respect to ranked comments:
Ranked Comments:
Comments Rank
FullName_Tel_Dup 1
FirstName_LastName_Tel_Dup 2
FullName_Fax_Dup 3
FirstName_LastName_Fax_Dup 4
Source Table Data:
ID Comments
1 FullName_Tel_Dup
2 FirstName_LastName_Tel_Dup
3 FirstName_LastName_Tel_Dup
1 FirstName_LastName_Fax_Dup
2 FullName_Fax_Dup
3 FirstName_LastName_Fax_Dup
1 FirstName_LastName_Tel_Dup
2 FirstName_LastName_Fax_Dup
3 FullName_Tel_Dup
And below should be the required output:
ID Comments
1 FullName_Tel_Dup
2 FirstName_LastName_Tel_Dup
3 FullName_Tel_Dup
Request your help for the above requirement and let me know if any further information is required.
Thanks and regards,
Rakesh