Answer Posted / santhi k

Using Top N analysis....


select * from (select rownum rn, col1,col2,col3 from
tablename) where mod(rn,5)=0;

What is the difference between web edition and business edition?

111

---

What is a performance monitor?

976

---

How self join is different from outer join?

1123

---

What's the information that can be stored inside a bit column?

1006

---

What is analysis service repository?

1025

---

how to overcome kernel isssues

1629

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2221

---

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4388

---

What stored by the model? : sql server database administration

958

---

What are transactions and its controls?

1061

---

What does man by sql wildcard characters in sql server?

1064

---

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1936

---

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

---

How to create a view on an existing table in ms sql server?

1128

---

How you would rewrite the sql query to return the customerid sorted numerically?

1001

---