Answer Posted / naren

select max(salary) as salary1 from employee where salary <
select max(salary) as salary2 from employee

Explain candidate key, alternate key, and composite key?

586

---

How to recover from sql injection? : sql server security

520

---

Delete duplicate rows without using rowid.

1063

---

Explain acid?

603

---

How to download and install microsoft .net framework version 2.0?

544

---

---

What are exact numeric data types in ms sql server?

508

---

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

572

---

What is GUID in sql server?

634

---

What is row_number () and partition by in sql server?

519

---

Explain the relational database management system (rdbms)?

518

---

What do you understand by coalesce in sql server?

493

---

How to create percentile function?

108

---

What is SQL Azure?

85

---

How do I view views in sql server?

514

---

How do I edit a procedure in sql server?

546

---