Answer Posted / karthik

select eno,count(1) cnt from emp
group by eno having count(1) > 1;

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1045

---

When should you use an instead of trigger?

1049

---

What is an indexed view?

1021

---

How to remove duplicate rows from table except one?

1087

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1068

---

How to convert numeric expression data types using the cast() function?

1146

---

do you know how to configure db2 side of the application? : Sql server database administration

1121

---

Can we do dml on views?

1035

---

Explain “row_number()” in sql server with an example?

1076

---

What are the properties of the transaction?

1070

---

What is a coalesce function?

1282

---

Can one drop a column from a table?

1086

---

Why and when do stored procedure recompile?

1056

---

Can sql servers link to other servers like oracle?

915

---

How to provide default values to function parameters?

1256

---