Answer / Mohit Tripathi

Common Table Expressions (CTEs) provide several benefits, including readability, modularity, and performance. They allow you to create temporary results sets that can be used multiple times within a query, making the code more maintainable and easier to understand.nnCTEs also offer better performance for complex queries because they are evaluated only once, reducing the need for repeated computations.

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

What are different types of statements that are supported by sql?

1 Answers  

---

What is save transaction and save point?

1 Answers  

---

what is unique and xaml nonclustered index

1 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

1 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,

---

How to send email from database?

1 Answers  

---

What are the benefits of filtered indexes?

1 Answers  

---

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

---

Describe triggers features and limitations?

1 Answers  

---

What is purpose of normalization?

1 Answers  

---