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 7705one 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 10736one 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 23248Post New TCS SQL PLSQL Interview Questions
What are the usages of the command object in ado.net?
Is use of DSS covered by any patents?
When we can update the application? Is server up time or downtime?
Mention two instances where routing is not implemented or required?
How do you ipconfig all?
How can you create css3 property for each corner?
What is a platform?
What is the fillfactor concept in indexes?
What type of memory is the stack?
What is the difference between an inner join and an outer join?
Write all the phases defined in servlet life cycle?
You want to automatically convert purchase requisition to purchase order. How would you configure the system?
Why is c++ called oops?
Do you know what are the steps required to modify config.xml file of web logic server?
What is the core naming mechanism, domain name system (dns)?