Answer Posted / ajit

select *
from emp
where sal = ( select max(sal)
from emp
where level = &n
connect by prior sal > sal
group by level);

What is the current version of postgresql?

1188

---

Is primary key always clustered index?

1101

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

What is the best sql course?

1064

---

what is schema? : Sql dba

1163

---

Does group by remove duplicates?

1121

---

How do I remove duplicates in two columns?

1202

---

what is collation? : Sql dba

1242

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

what are the advantages of sql ? : Sql dba

1154

---

what is bcp? When does it used? : Sql dba

1065

---

Can delete statement be rollbacked?

1065

---

what is sql server agent? : Sql dba

1189

---

Is primary key clustered index?

1028

---

What is your daily office routine?

2353

---