Answer Posted / sachin

select max(salary) from emp_salary where salary<(select
max(salary) from emp_salary);

What is a rank in sql?

542

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

6089

---

What are all different types of collation sensitivity?

529

---

How do I view a sql database?

564

---

What is the difference between left and left outer join?

518

---

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

525

---

Is delete faster than truncate?

555

---

Why is the cursor important?

543

---

What is cost in sql execution plan?

492

---

Can you have more than one trigger on a table?

532

---

what is bcp? When does it used? : Sql dba

526

---

What is %type in sql?

522

---

what is uncommittable transactions? : Transact sql

572

---

Explain the update statement in sql

565

---

How can you fetch common records from two tables?

594

---