Answer Posted / srikanth

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

Explain 3 basic parts of a trigger.

1327

---

Write a query to display the current date in sql?

1026

---

What is varchar sql?

1150

---

What is sql performance tuning?

924

---

Explain normalization and what are the advantages of it?

953

---

Can a key be both primary and foreign?

999

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1068

---

What does rownum mean in sql?

1030

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

---

What are the types of queries in sql?

1086

---

What is difference between left and right outer join?

991

---

how many sql dml commands are supported by 'mysql'? : Sql dba

1125

---

how do you tune the slow running queries in oracle db , explain the methodology

2813

---

What is nvarchar max in sql?

1021

---

How to download oracle sql developer?

1113

---