How to delete duplicate rows in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Is BCNF better than 2NF & 3NF? Why?
0 Answers Akamai Technologies,
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
How many types of cursor type are there?
1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format
Comment,Datatypes are unlimited
Explain cdc and sql injection?
How do I find the default sql server instance?
How do I make a resultset scrollable?
please differentiate between delete and truncate?
What stored procedure can you use to display the current processes?
How to change location of errorlog in SQL?
Can one drop a column from a table?
Oracle (3253)
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)