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
Answer / ramya
select * from test_1 where name is not null and age is not
null;
| Is This Answer Correct ? | 18 Yes | 2 No |
how many ways we can we find the current date using mysql? : Sql dba
I want to know the difference between A Record Type and a Table.
how to create a primary key with out creating an index?
Which function is used to return remainder in a division operator in sql?
write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.
How to run sql commands in sql*plus?
how do you login to mysql using unix shell? : Sql dba
What is write ahead logging in sql server?
What does select count (*) mean in sql?
What does sign mean sql?
What is the use of pl/sql table?
What is embedded sql what are its advantages?
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)