display null value rows with out using null function?
Answer Posted / ansupriya
select * from emp where nvl(to_char(comm),'null')='null';
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is microsoft t sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
How does sql store data?
What are the parts of a basic sql query?
What does varchar include?
What is the difference between a subquery and a join?
What trigger means?
What is user defined functions?
What is scalar and vector?
what is sp_pkeys? : Transact sql
Is left join faster than join?
What is primary key and foreign key with example?
Write a query to find the names of users that begin with "um" in sql?
How to pronounce postgresql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????