wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

What is primary key and foreign key with example?

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

Is primary key an index?

0 Answers  

---

Is sql a programming?

0 Answers  

---

What are the types of triggers ?

26 Answers   Aspire, BirlaSoft, TCS,

---

What is coalesce sql?

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---