i have a table with fields(id,name,accnt_type)and in account type are FD,SAVING,RD. Write a query to get How many number of People are in each type of Account?

6 Answers   Fidelity, IBM,

---

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

---

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

---

Explain ttitle and btitle.

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is a cursor for loop ?

4 Answers  

---

Can you have a foreign key without a primary key?

0 Answers  

---

Is sql scripting language?

0 Answers  

---

how to fetch common records from two tables? : Sql dba

0 Answers  

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

What is t-sql? : Transact sql

0 Answers  

---