Answer / sam

select * from emp where empid >=5 and empid <=7

Explain atomicity?

0 Answers  

---

How to achieve Paging of records in SQL SERVER?

0 Answers   Petranics Solutions,

---

How to round a numeric value to a specific precision?

0 Answers  

---

What is normalization according to you and explain its different levels?

0 Answers  

---

How to delete an existing row with delete statements in ms sql server?

0 Answers  

---

What is the Disadvantage of indexed sequential file.

0 Answers   HCL,

---

Can you roll back the ddl statement in a trigger?

0 Answers  

---

What can be used instead of trigger?

0 Answers   ADITI,

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

What are the types of stored procedures in an sql server?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

12 Answers   Accenture,

---