Does a server store data?
No Answer is Posted For this Question
Be the First to Post Answer
Define Joins?
How each E-R model constructs can be mapped to the relational model?
What is the tcp/ip port on which sql server runs?
How many types of stored procedures are there in sql server?
Explain how to integrate the ssrs reports in application?
How to return the top 5 rows from a select query in ms sql server?
How to test subquery results with the exists operator?
What are the source of constraints?
between cast and convert which function would you prefer and why?
What are the OS services that the SQL Server installation adds?
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005
Hi All, I want to display all duplicate records in the table. My query has to fetch all the records which are duplicate(First Name or Last Name). Also I want the ability to also pull names where there might be a middle initial placed in the end of the first name field, (i.e., "Maria Z. " vs. "Maria") as well. Please guide me to find this. Table: ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 4 Shawn Livermore 5 Prem S 6 Jony Hoffman H 7 Zach Modan I need the query to filter......... ID FirstName LastName 1 Zach H Hoffman 2 Zach Hoffman 3 Troy Hoffman 6 Jony Hoffman H 7 Zach Modan I hope this example will give you clear idea..... Thanks in Advance Prem