i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?

8 Answers   Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,

---

Name some fields from SQLCA.

2 Answers  

---

what's the error code for Unique Index Violation?

2 Answers  

---

Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  

---

How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

What techniques are used to retrieve data from more than one table in a single SQL statement?

2 Answers  

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

What is a cursor and what is its function?

2 Answers  

---

Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?

3 Answers  

---

Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?

1 Answers  

---

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,

---