write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
3 7702one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?
9 10735one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
13 23247Post New TCS SQL PLSQL Interview Questions
What are the essential of internal audit?
How can we make each word in a text start with a capital letter?
what is the procedure for Excisable goods transfer from Head office to branch and vice versa (the branch is located in the same state) also if the branch is located in other states. How will it affect the VAT returns
How to disable/enable an element in jquery?
Can you define an argument as a reference type?
What is the difference between borland silk and selenium?
Can sports drinks causes wreck teeth?
In simple terms, what is the internet of things?
What is servo motor and what are the applications of servo motor?
Are linked lists useful?
i am fresher for giving intervivew in it sector and also sales electronics. all about related qustions send me please?
Why commit is not used in triggers?
What is meant by a context menu in a cad software?
which type of zones used for boiler? & why ?
What is mvc view engine?