Answer Posted / saurabh tyagi

select id ,partcode from prt where id in
(

select case when row_number() over (order by partcode ) %
5 = 0
then row_number() over (order by
partcode)
else 0 end
from prt
)

How to download and install the scaled-down database adventureworkslt?

992

---

Define normalisation?

1114

---

Tell me what is fill factor?

963

---

How to connect a database with sql express.?

1062

---

What are examples of triggers?

1088

---

What is an index. What are the types?

1090

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

---

What is 5nf in normalization form?

992

---

Do you know how to make remote connection in database?

965

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

968

---

Explain different backup plans?

942

---

What is an example of a primary key?

991

---

What are cursors stored procedures and triggers?

1019

---

What you can do to delete a table without the delete trigger firing?

973

---

What is filter index?

951

---