Answer / ramya

select * from test_1 where name is not null and age is not
null;

What is primary key and unique key?

0 Answers  

---

I have a table .in the table 100 recored is there .we have get the single row with out using clause..

3 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

What is record variable?

0 Answers  

---

How do I enable sql encryption?

0 Answers  

---

What is sqlerrm?

0 Answers  

---

What is the difference between a database and a relational database?

0 Answers  

---

What is a schema in sql?

1 Answers  

---

Can we insert data into view?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

0 Answers  

---

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,

---