Sql Queries: A Table will be given
Omiting Duplicate rows and adding a new column
- 1 Answers
- 2498 Views
- I also Faced
- E-Mail Answers
Answer / Gaurav Prakash
Here's an example of removing duplicate rows from a table using the DISTINCT keyword in SQL:n```sqlnSELECT DISTINCT column1, column2 FROM your_table; n```nTo add a new column, you can use the CAST or CONVERT functions to convert an existing column to a specific data type. For example, if you want to create a new column named 'NewColumn' with the first letter in uppercase from the existing 'column1':n```sqlnALTER TABLE your_table ADD NewColumn AS UPPER(column1); n```
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain about Behavioral design pattern?
How many design patterns can be created in .net?
How do you trigger the paint event in system.drawing?
What is the difference between a namespace and assembly name in .net?
What?s typical about a Windows process in regards to memory allocation?
Tell us the differences between an interface and an abstract class in .net?
Why inheritance is important?
What is .net environment?
What is Polymorphism? How does VB.NET/C# achieve polymorphism?
What is Nothing permission set in .Net
what user controls are and what server controls are and the differences between the two.
Difference between value type & reference types ?
Dot Net Framework 
