What is create statement?

0 Answers  

---

Differentiate between mongodb vs. Sql server?

0 Answers  

---

What is the usage of the sign function?

0 Answers  

---

What are the advantages of sql stored procedure?

0 Answers  

---

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  

---

---

What is the difference between Stored Procedures and triggers?

0 Answers   HCL,

---

Explain sql delete command?

0 Answers  

---

What is the use of sql profiler in sql server 2012?

0 Answers  

---

Where sql server usernames and passwords are stored in a sql server?

0 Answers  

---

Explain relational data?

0 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

6 Answers   Tech Mahindra,

---