how do we find every fifth record in a table

Answer Posted / vijaya

select * from employee where employeeID % 5=0

Is This Answer Correct ?    4 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can sql server 2016 run on windows 7?

515


How do I view a procedure in sql server?

549


What sql server means?

566


What are the advantages of user-defined functions over stored procedures in sql server?

472


Explain about protocol layer present in SQL server?

613






How would you add a section to a table?

581


How do you create type- insensitive operator?

574


What is partitioned view?

531


what authentication modes does sql server support? : Sql server database administration

539


What is use of dbcc commands?

633


Explain ms sql server reporting services vs crystal reports?

509


ow to bring suspect mode datbase online from scratch

1415


What happens when unicode strings concatenate with non-unicode strings?

552


How to create an identity column?

647


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

689