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
- 7208 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
What is oracle pl sql developer?
What is a data manipulation language?
What is sql select statement?
What is the usage of distinct keyword?
Explain sql data types?
Can we insert data in view?
What is the difference between having and a where in sql?
What are the two characteristics of a primary key?
what are the join types in tsql? : Transact sql
How does postgresql compare to mysql?
Explain locks? : Transact sql
What is the most common sql injection tool?
What is an invalid partition table?
Can we create foreign key without primary key?
How to return an array from java to pl/sql?
