Answer Posted / hridayeshwar rao

select max(age) from yd where age<(select max(age) from HK) ; /// True two table Highest

SELECT * FROM HK E1 WHERE 1 =(SELECT COUNT(DISTINCT age) FROM HK E2 WHERE E1.age < E2.age); ///Second Hightest age RT single table

select age from hk e1 where (3-1) = (select count(distinct (e2.age)) from yd e2 where e2.age>e1.age);//// same True Second Hight age RT two table

select max(age) from YD where age not in (select max(age) from YD); //second hight age in single table

Suppose that salery=age

Thanks !!!

What is union, minus and interact commands?

1300

---

How do I make sql search faster?

1001

---

What is a loop in sql?

989

---

What is faster join or subquery?

1013

---

What is data profiling in sql?

1084

---

Is sql pronounced sequel or sql?

1273

---

What is the function that is used to transfer a pl/sql table log to a database table?

1026

---

Explain the types of joins in sql?

1035

---

What are three advantages to using sql?

1024

---

How can you fetch common records from two tables?

1063

---

what is the difference between primary key and unique key? : Sql dba

1039

---

what are the 'mysql' command line options? : Sql dba

1076

---

Why stored procedures are faster than query?

1029

---

Define concurrency control. : Transact sql

1193

---

what is a stored procedure? : Sql dba

1137

---