Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 25028 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / sudhagar
Delete from (select * from <TABLE_NAME> where rowid not in
(select min(rowid) from <TABLE_NAME> group by c1,c2...))
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What samples and sample databases are provided by microsoft?
What are the difference between primary key and unique key? : sql server database administration
How to change server name in sql server?
What number aggregate functions are accessible there in sql?
What is the default port for SQL Server over a firewall?
Do you know what are acid properties?
Is it possible to call a stored procedure within a stored procedure?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How you can find out if an index is useful to the optimizer?
What are the advantages of sql stored procedure?
What are the advantages of log shipping?
What is 'Join' and explain its various types.
What do you understand by a view? What does the with check option clause for a view do?
Does transparent data encryption provide encryption when transmitting data across the network?
