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
- 6648 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 heap table? : Sql dba
Is ms sql is free?
What is bind variable in pl sql?
How do I start pl sql?
How to start the command-line sql*plus?
what is a database transaction? : Sql dba
how to escape special characters in sql statements? : Sql dba
Is sql port 1433 encrypted?
Why partition by is used in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Can we use distinct and group by together?
What is trigger point?
How much does sqlite cost?
What is pl sql and why it is used for?
What is difference between mysql and postgresql?
