Answer / sreeja.t.pillai

SELECT MIN(EmpSal) Min_Salary FROM Employee_Details

Answer / kk

SELECT DISTINCT TOP 1 salary
FROM tblemp
ORDER BY salary ASC

Answer / saiteja

select ename,sal from emp
where sal=(select min(sal) from emp);

Answer / indraneelandhavarapu

SELECT MIN(SALARY) from EMPSAL

OR

SELECT MAX(SALARY) FROM
(SELECT DISTINCT TOP 1 SALARY
FROM EMPSAL ORDER BY SALARY) AS A;

What is named query? : sql server analysis services, ssas

0 Answers  

---

What is the difference between login and a user?

13 Answers   CTS, TCS,

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

Can you index views?

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

what is call by value & call by reference ?

2 Answers   Cap Gemini,

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---

What is amo? : sql server analysis services, ssas

0 Answers  

---

What is log shipping?

0 Answers  

---

What are policy management terms?

0 Answers  

---