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

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

0 Answers  

---

How to list all columns in a table using odbc_columns()?

0 Answers  

---

Difference Between varchar and nvarchar datatype?

3 Answers   Satyam,

---

Write a query to delete duplicate records in SQL SERVER

36 Answers   Infosys,

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

Explain logical operators in sql server?

0 Answers  

---

why SQL server is more used to store database rather than Access

2 Answers  

---

What are the transaction properties?

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

0 Answers  

---

Explain what are db_options used for?

1 Answers   InterGraph,

---

What is Sqlpaging in SqlServer 2005 ?

0 Answers   MCN Solutions,

---