Answer Posted / deven

select top 1 salary from emp where salary <>(
select top 1 salary from emp order by salary desc) order by
salary desc

Why is nosql good?

599

---

What is range partitioning?

522

---

how to dump a table to a file with 'mysqldump'? : Sql dba

555

---

what is datawarehouse? : Sql dba

573

---

What programs use sql?

529

---

---

What is not in sql?

502

---

How does index help in query performance?

568

---

Explain the components of sql?

595

---

how to show all tables with 'mysql'? : Sql dba

610

---

What is the difference between local variables and global variables?

617

---

What does (*) mean in sql?

527

---

Does a user_objects view have an entry for a trigger?

573

---

What is sp_helptext?

592

---

What is difference between pls_integer and integer?

522

---

Can you upgrade sql express to full sql?

520

---