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
- 6673 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kart
select * from table where id is not null;
| Is This Answer Correct ? | 17 Yes | 3 No |
Post New Answer View All Answers
What is the best partition size for windows 10?
What is clause?
what is the difference between undefined value and null value? : Sql dba
Can we call a function containing dml statements in a select query?
what is the difference between a having clause and a where clause? : Sql dba
How is sql used in oracle?
What is sharding in sql?
What is a natural join?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is memory optimized?
What does select * from mean in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Is microsoft sql free?
What are two statement types in sql?
What is a stored procedure in sql with example?
