Interested to Buy Any Domain ? << Click Here >> for more details...
in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only.
- 7 Answers
- 10064 Views
- I also Faced
- E-Mail Answers
Answer Posted / dinesh gupta
use distinct commond
distinct(ename) from table name
| Is This Answer Correct ? | 0 Yes | 2 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 is the difference between for auto and for nested?
What are the advantages of log shipping?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
What is acid mean in sql server?
How to enter date and time literals in ms sql server?
What is multilevel indexing?
What is difference between standardization and normalization?
In which files does sql server actually store data?
What is a join in sql? What are the types of joins?
How to test subquery results with the exists operator?
Differentiate between ms sql server reporting services vs crystal reports?
Explain activity monitors
How can we call UDF(User Define Function) using C# code in ASP.net ?
Explain the properties of a relational table?
