What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 60654I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
13 15668Post New DELL SQL Server Interview Questions
What are expert systems in artificial intelligence?
What is a Manifest file?
Differentiate between late binding and early binding. What are the advantages of early binding?
How to score well in examination of MCA(engg) december 2012? please reply soon........
How can we tune a sql query to optimize the performance of a database?
How many rows can a mysql table hold?
what is the advanteg of ricombinant antigen?& what is the advanteg of sinthethick antigen? and advanteg of both?
What does redo statement do in perl?
Which namespace is used by ado.net?
What is tableau show me?
How will you handle a conflict amongst your team members?
What is transport and message reliability?
What is load line in control valve?
How can you optimize the i/o performance?
What is an activity type? : co- cost center accounting