Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76581 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
Mr. Chandran, I tried your query but the system is throwing
error message as 'Incorrect syntax near the
keyword 'group''.
| Is This Answer Correct ? | 28 Yes | 14 No |
Post New Answer View All Answers
Why use “in” clause in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Find nth lowest salary or get nth lowest salary?
What is logshipping and its purpose?
Can you use order by when defining a view?
How would we use distinct statement? What is its use?
Explain the database you used in your final year project?
Explain the concept of recursive stored procedure.
Explain partitioned view?
What is meant by datasource?
Write the SQL query to drop, truncate and delete table.
Explain different types of index?
Can primary key be a foreign key?
How to create view in stored procedure sql server?
Which table keeps information about stored procedures?
