Answer Posted / anuj maheshwari

select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));

What is server name sql?

1153

---

What do we need to check in database testing?

1026

---

where are cookies actually stored on the hard disk? : Sql dba

1032

---

Can you join a table to itself?

1138

---

how can we know the count/number of elements of an array? : Sql dba

1066

---

Determine if oracle date is on a weekend?

1042

---

What is varchar sql?

1152

---

What is difference between ms sql and mysql?

971

---

Explain two easy sql optimizations.

1019

---

Explain isolation levels. : Transact sql

1074

---

What are the uses of merge?

1168

---

How can I make sql query run faster?

1018

---

Can we join 3 tables in sql?

1049

---

what is the command line end user interface - mysql? : Sql dba

984

---

Which is better trigger or stored procedure?

955

---