Answer / ravikiran

select top 2(salary) from emp_sal where
salary in (select sal from emp_sal order by sal desc)

What are the types of database recovery models?

0 Answers   HCL,

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

How to access the deleted record of an event?

0 Answers  

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

Can the “if update (colname)” statement be used in a delete trigger?

0 Answers  

---

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

What is SQL Server?

0 Answers   Atos Origin,

---

How to drop an existing table?

0 Answers  

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

0 Answers   ADP, iSoft,

---

Explain full-text indexing?

0 Answers  

---

What is use of except clause?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---