Interested to Buy Any Domain ? << Click Here >> for more details...
write a query filter the null value data following source?
name age
john 30
smith null
null 24
sharp 35
i want output
name age
john 30
sharp 35
- 1 Answers
- 5378 Views
- TCS, I also Faced
- E-Mail Answers
Answer / ramya
select * from test_1 where name is not null and age is not
null;
| Is This Answer Correct ? | 18 Yes | 2 No |
What is a file delimiter?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
What is the most important ddl statements in sql are?
Does postgresql run on the cloud?
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What are the operators used in select statements?
Is oracel sql developer written in java?
What is the importance of sqlcode and sqlerrm?
What do you understand by case manipulation functions?
What does count (*) mean?
What is execute immediate?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
