Answer Posted / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

What is the architecture of ms sql reporting service?

925

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1089

---

How to include date and time values in sql statements?

1047

---

Why should one not prefix user stored procedures with ‘sp_’?

987

---

What is use of except clause?

1037

---

What is the report builder?

131

---

How to create new tables with "create table" statements in ms sql server?

1001

---

What is log cache in sql server?

985

---

What stored procedure would you use to view lock information?

905

---

What is transaction server isolation?

978

---

What are approximate numeric data types in ms sql server?

1011

---

Explain the difference between function and stored procedure?

900

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

941

---

Is sql server 2016 free?

886

---

What are filegroups in sql server?

1014

---