Interested to Buy Any Domain ? << Click Here >> for more details...
how do we find every fifth record in a table
- 14 Answers
- 18253 Views
- Aspire, HCL, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is subquery in sql?
What is key attribute?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What happens if null values are involved in string operations?
How you would rewrite the sql query to return the customerid sorted numerically?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
Do you know what is difference between stored procedure and user defined function?
What is stored procedures?
Is there any difference between the primary key and unique key?
Can we call future method from trigger?
Explain what is the function of sql server agent windows service?
What are different types of join?
How to create a view using data from another view?
Explain mixed authentication mode of sql server?
