how do we find every fifth record in a table
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
How to make conditional sum in ssrs?
What is the difference between for trigger and after trigger?
Explain insert into select statement?
What is 3nf normalization form?
Differentiate between SQL and ORACLE joins and write their syntax.
Difference between primary key and clustered index?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to connect of datebase with sql express.?
What is the cartesian product of table?
What is lookup override?
Explain data warehousing in sql server?
What command would you use to add a column to a table in sql server?
Distinguish between nested subquery and correlated subquery?
Write the SQL query to drop, truncate and delete table.
What is normalization and denormalization in sql server?