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

Can we store videos inside the sql server table?

0 Answers  

---

Can you explain powershell included in sql server 2008?

0 Answers  

---

What is index fragmentation in ms sql server?

0 Answers  

---

What is Inner Join?

2 Answers  

---

What is an indexed view?

0 Answers  

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

0 Answers   HCL,

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

How to verify a login name with sqlcmd tool?

0 Answers  

---

How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

0 Answers  

---

Why functions are used in sql server?

0 Answers  

---

What is bcp? When does it used?

0 Answers  

---