Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

what do you understand by change data capture?

0 Answers  

---

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

---

What is cursors?

0 Answers   NA,

---

What is view in sql?

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

Can we call a function that has out parameter in select statement

0 Answers   Nagarro,

---

Where can you add custom error messages to sql server?

0 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,

---

can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,

---

What is openxml in sql server?

0 Answers  

---

How to copy data from one table to another table?

0 Answers  

---