display null value rows with out using null function?
Answer Posted / harinadh bolisetti
in case of integer data type column.
select * from emp
where nvl(deptno,1)=1
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are triggers and its uses?
How do I order by ascending in sql?
How do I create a sql script?
how to add a new column to an existing table in mysql? : Sql dba
How delete a row in sql?
What information is needed to connect sql*plus an oracle server?
how to convert character strings to dates? : Sql dba
How many aggregate functions are available there in sql?
How do you define a foreign key?
How do I remove all records from a table?
What is sql resultset?
How can triggers be used for the table auditing?
How do I clear the screen in sql plus?
Can we insert data into materialized view?
What sql does db2 use?