how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---

What are the data types allowed in a table?

3 Answers  

---

What is trigger and how to use it in sql?

0 Answers  

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

---

Can cursors be part of a trigger body?

0 Answers  

---

What are the ddl commands?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

---

Why do we need view in sql?

0 Answers  

---

How to add Foreign key in a table after the creation of the table?

5 Answers   Satyam,

---