Answer Posted / swapnil tikale

Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;

Which type of cursor is used to execute the dml statement?

962

---

How to use boolean type in select statement?

1084

---

What is a table partition?

1142

---

Why we use join in sql?

980

---

Can sql developer connect to db2?

1057

---

How to rename a table?

1031

---

what are the security recommendations while using mysql? : Sql dba

1125

---

How much does sql certification cost?

1095

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1056

---

what are all the different types of indexes? : Sql dba

1052

---

how to convert character strings to numeric values? : Sql dba

1112

---

Does mysql support pl sql?

1178

---

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

1058

---

what is normalization? : Sql dba

1089

---

Which is faster count (*) or count 1?

1038

---