Answer Posted / bhramar

select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal

Display the employees whose salary is less than average salary.

1064

---

What is database and its types?

1005

---

Explain inner and outer joins with examples.

1173

---

What is lagging in DBMS ?

1256

---

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2547

---

What is redis good for?

957

---

Explain partial key?

1087

---

query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

2053

---

Explain database partitioning. What is its importance?

1193

---

List various types of log-based recovery in DBMS.

988

---

WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?

2967

---

Explain about ur projets on teradata???

1768

---

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

---

What is a trace file?

1067

---

sparse lookup and where its options we find in OCI and db2?

2219

---