Answer Posted / arnab bhui

Using Oracle........

create table emp
( id number(10),
sal numeric(10,5)
);

SQL> select max(sal) from (( select sal from emp ) minus ( select sal from emp where sal >= all ( select sal from emp )));

how you can configure a running aggregate in SSRS?

199

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1115

---

List the advantages of using stored procedures?

1106

---

How to concatenate two binary strings together?

1175

---

wat wil hapn if we give the both read and deny read permission to user?

2151

---

what is denormalization? : Sql server database administration

973

---

How can you find out how many rows returned in a cursor?

1084

---

How to create a simple table to test triggers in ms sql server?

1034

---

How can we improve performance by using SQL Server profiler?

1108

---

What are the different types of upgrades that can be performed in sql server?

1212

---

What is dbcc updateusage?

1257

---

Does a sql server 2005 select statement require a from?

1071

---

What is a covering index?

1042

---

Why do we use stored procedures in sql server?

997

---

Detail about the hardware which is supported by SQL server?

1118

---