What is difference between table aliases and column aliases? Do they affect performance?
No Answer is Posted For this Question
Be the First to Post Answer
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
Different types of keys in SQL?
what is sql server? : Sql server database administration
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
What is in place upgrade in sql server?
Can sql servers link to other servers like oracle?
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
How will you monitor replication latency in transactional replication? : sql server replication
What is onf in normalization form?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What is page in sql server?
Explain the database you used in your final year project?
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)