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

What do you mean by COLLATION?

4 Answers   ABC, BirlaSoft,

---

How to modify an existing user defined function?

0 Answers  

---

hi. suppose one person goal is strong knowledge on SQL.... suggest me ...if he learns SQL SERVER or ORACLE? which is best?

7 Answers   Google, TCS, Unisys,

---

What is an example of a foreign key?

0 Answers  

---

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

1 Answers   Cognizant,

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

0 Answers  

---

What are sql servers used for?

0 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

0 Answers   Cap Gemini,

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---

How do we know if any query is retrieving a large amount of data or very little data?

0 Answers  

---

Explain trigger and trigger types?

0 Answers  

---