Explain “row_number()” in sql server with an example?

0 Answers  

---

Explain transaction server auto commit?

0 Answers  

---

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

---

Explain the different index configurations a table can have?

0 Answers  

---

What is resource db in sql server?

0 Answers  

---

Do you know clustered and non-clustered index?

0 Answers  

---

What is correlated subquery in sql server?

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  

---

How data can be copied from one table to another table?

0 Answers  

---

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

Difference between aggregate functions of sql?

0 Answers   EXL,

---