Answer Posted / gopi mandadi

Select emp_no,name,dept,sal from emp_t A
Where &n = (Select sal from emp_t B Where A.sal <= b.sal)

What is the maximum size per database for sql server express?

1063

---

What are statistics?

1013

---

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

981

---

what is checksum in sql server.........???

1698

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

995

---

What are the reporting services components?

144

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

993

---

what is the sql equivaent of the dataset relation object ?

2038

---

what information is maintained within the msdb database? : Sql server administration

983

---

What is the difference between functions and stored procedures?

1177

---

What is the ‘fillfactor’?

973

---

How do I view a procedure in sql server?

1000

---

Explain Geography datatype in SQL Server

1144

---

What do you mean by table and field in sql?

1023

---

How to enable tcp/ip protocol on a sql server?

1180

---