Answer Posted / bharat g

select * from (select ename,sal,dense_rank() over (order by sal desc) ranking from emp) where ranking=2;

What is offset and limit in sql?

1065

---

Is sql free?

975

---

Compare sql & pl/sql

1143

---

How many joins can you have in sql?

940

---

What has stored procedures in sql?

1070

---

What is not equal in sql?

1131

---

what is a database lock ? : Sql dba

1176

---

how can we find the number of rows in a table using mysql? : Sql dba

1089

---

What are the different dcl commands in sql?

1180

---

What is embedded sql with example?

1056

---

Is sql better than access?

1021

---

explain the difference between delete , truncate and drop commands? : Sql dba

1098

---

what's the difference between a primary key and a unique key? : Sql dba

1055

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1136

---

Explain the savepoint statement.

1102

---