Answer Posted / shahid

select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;

Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar

1972

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1607

---

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

2004

---

Can you create a database in word?

1041

---

What advantages does DBMS have over traditional file systems?

1035

---

how can you perform lookup range in lookup stage expalin in detail?

1934

---

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1133

---

Explain various types of locks in a transaction? Which is better and why?

1024

---

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

1380

---

Explain artificial key?

1168

---

Is data lake a database?

967

---

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2646

---

What is ole db provider for sql server?

1029

---

List various types of log-based recovery in DBMS.

988

---

Should I store images in database?

1026

---