Answer Posted / indraneelandhavarapu

SELECT MIN(SALARY) from EMPSAL

OR

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

How is foreign key related to primary key?

973

---

Difference between uniqe index and uniqe constraint?

986

---

How to check status of stored procedure in sql server?

990

---

Which tools are available to manage SQL Azure databases and servers?

115

---

What is the bookmark lookup and rid lookup?

998

---

Explain about SQLOS?

1015

---

Write a program to fetch first 10 records from a file?

1017

---

How to optimize stored procedure optimization?

898

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

912

---

What are the different types of backups avaialabe in sql server 2005?

1023

---

Different types of keys in SQL?

1103

---

what are the new features in SSRS?

134

---

What will happen if a column containing char type data is changed to the nchar data type?

1110

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1104

---

What is the rdl file?

139

---