Answer Posted / prashant

select max(salary) from
(select distinct(salary) from ABC)

How can we link a sql database to an existing android app?

1033

---

How many types of indexes are there in sql?

985

---

How can we make an if statement within a select statement?

1016

---

Why do you partition data?

1027

---

Can a foreign key have a different name?

941

---

What is your daily office routine?

2273

---

Is join and inner join the same?

1009

---

Explain what is sql*plus?

1149

---

What are the dml statements?

1144

---

What is rename in sql?

978

---

What is a constraint?

1027

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1029

---

What is sap sql?

988

---

What does desc stand for?

1075

---

Is primary key an index?

996

---