What are the types of normalization?
No Answer is Posted For this Question
Be the First to Post Answer
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
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
Can I run multiple instances of sql server 2000 at the same time on one computer?
What is a transactions?
How do you troubleshoot errors in a SQL Server Agent Job?
Why use stored procedures in sql server?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
What are logical/boolean operations in ms sql server?
How to enter date and time literals in ms sql server?
What are a scheduled jobs or what is a scheduled tasks?
How to write an inner join with the where clause in ms sql server?
What stored by the model? : sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)