What command would you use to create an index?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

---

What is 5nf in normalization form?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,

---

What is update_statistics command?

0 Answers  

---

What are different types of constraints?

0 Answers  

---

What is the difference between mysql and mysqli?

0 Answers   HCL,

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

---