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 not equal in sql?

1056

---

Why procedure is used in sql?

1000

---

What is the syntax to add a record to a table?

1050

---

How to select unique records from a table?

1018

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3967

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2039

---

Is hadoop a nosql?

962

---

What can I use instead of union in sql?

925

---

Can we use loop in sql?

946

---

What are two statement types in sql?

1054

---

What is data profiling in sql?

1036

---

What are pl/sql cursor exceptions?

1050

---

What is meant by <> in sql?

914

---

What makes a good primary key?

1005

---

how to dump a table to a file with 'mysqldump'? : Sql dba

1008

---