Home > IT Answers > Database > Fetchind duplicate rows from a table
Sri24
5 pts.
 Fetchind duplicate rows from a table
Database, Fetchind
A table has appox 60 fields. i would like to fetch all the rows having all values of the field equal excpet 3 fields.

Software/Hardware used:
ASKED: April 8, 2008  2:19 PM
UPDATED: April 8, 2008  6:58 PM
RELATED QUESTIONS
Answer Wiki:
I'd check out <a href="http://itknowledgeexchange.techtarget.com/sql-server/">SQL Server with Mr. Denny</a> for more information... But I would think that a command similar to the following would do the trick (I don't have a sql server I can test with at the moment): select * from tablename where fieldname not like '%string1%' and fieldname not like '%string2%' and fieldname not like '%string3%'
Last Wiki Answer Submitted:  April 8, 2008  6:58 pm  by  Jerry Lees   5,320 pts.
All Answer Wiki Contributors:  Jerry Lees   5,320 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _