How do I find the default sql server instance?

0 Answers  

---

Why is DML provided?

1 Answers   Ernst Young, Thomson Reuters,

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

Write a query for primary key constraint with identity key word?

0 Answers   MindCracker,

---

What is query and its types?

0 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What is the difference between index seek vs. Index scan?

0 Answers  

---

How to list all user names in a database?

0 Answers  

---

What is difference between inner join and join?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

how to delete duplicate rows from table in sql server

12 Answers   HCL, UHG,

---