you are sorting a table using "order by"(descending) clause of a col

you are sorting a table using "order by"(descending) clause of
a column which contains a null value...whether that row
containing null value will come first or last in the output??

Question Posted / vignesh lakshmirajan

2 Answers
5860 Views
BirlaSoft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

you are sorting a table using "order by"(descending) clause of a column which contains ..

Answer / vignesh lakshmirajan

The column contains null value will come first.. COz oracle consider the null value as larger value in this case....

Is This Answer Correct ?

15 Yes

0 No

you are sorting a table using "order by"(descending) clause of a column which contains ..

Answer / suman rana

if you are sorting a table using "order by"(descending)
clause of a column which contains a null value, row
containing null value will come first. Alternatively you can
use the clause "Nulls First" along with order by clause to
appear the Null values first.

Is This Answer Correct ?

9 Yes

0 No

Post New Answer

More Oracle General Interview Questions

what is the difference between substr and instr function in oracle?

0 Answers

Is a rollback possible to any savepoint?

0 Answers

How to fetch the row which has the max value for a column?

0 Answers

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers Accenture,

How to create a table in a specific tablespace?

0 Answers

What is an Oracle index?

0 Answers

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers iFlex,

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 Answers

Explain the blob datatype?

0 Answers

1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.

0 Answers TCS,

defination of bitmap index

0 Answers NIIT,

what is the difference between data migration and production migration.

0 Answers

For more Oracle General Interview Questions Click Here