Answer / satya gupt

select salary from emp e where 4=(select count(salary) from
emp where salary>e.salary

Answer / kumar.t

Table Name Is Employee
EmployeeId Is Identity field

Select * From Employee Where EmployeeId In (Select
EmployeeId From Employee Where EmployeeId%5=0)

by
Kumar.T

Answer / santhi k

Using Top N analysis....


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

Answer / vijaya

select * from employee where employeeID % 5=0

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

---

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

---

Normalization and denormalization

3 Answers   Wipro,

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---

What is index, cluster index and nonclustered index?

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

What is filestream?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

what is the difference between group and having give an example with query and sample output

7 Answers  

---

What is logshipping and its purpose?

0 Answers  

---