Answer Posted / ramu

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

What is composite primary key in sql?

524

---

what happens if null values are involved in expressions? : Sql dba

565

---

What is native sql query?

552

---

What is clustered index in sql?

591

---

What is left join in sql?

584

---

---

What is data control language?

532

---

What is full join in sql?

526

---

What is the difference between view and stored procedure?

496

---

What is the maximum number of columns in sql table?

551

---

What is count * in sql?

555

---

Do we need commit after truncate?

613

---

How do you declare a variable in pl sql?

535

---

Is stored procedure faster than query?

564

---

what are the difference between clustered and a non-clustered index? : Sql dba

529

---

When is the update_statistics command used?

572

---