Answer Posted / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

what is a record in a database ? : Sql dba

994

---

What are different joins used in sql?

1007

---

what is log shipping? : Sql dba

1055

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

---

How do I write a sql query in pgadmin 4?

923

---

What is the use of desc in sql?

913

---

what is unique key constraint? : Sql dba

990

---

Does sql support programming?

1006

---

What is cold data?

897

---

What is a data manipulation language?

963

---

Are sql database names case sensitive?

934

---

what is collation? : Sql dba

1077

---

Can you have more than one key in a database?

890

---

What is group function in sql?

963

---

What does pragma mean?

971

---