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 Answers
- 6671 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sumit
select id,name from table where id is not null;
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to download oracle sql developer?
What is pivot table in sql?
Explain what is a view?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is the use of sql trace?
What is the difference between distinct and unique in sql?
what is rollback? : Sql dba
How do sql databases work?
Can sql function call stored procedure?
How do I view a sql trace file?
What is foreign key sql?
What is the difference between sql and mysql?
Define tables and fields in a database
Why is stored procedure faster than query?
What is pl sql quora?
