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
- 5301 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 |
Give the structure of the procedure ?
What type of database is sql?
Are null values same as that of zero or a blank space?
What are the types of SQL Statement?
How toimport .dmp file in lower version of oracle from higher version ?
What is auto increment feature in sql?
What is a relationship and what are they?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
What is cartesian join in sql?
overloading of stored procedure is possible in oracle?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is sql analyzer?
-
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)
