What is a self join? Explain it with an example?

Answer Posted / mangi

answer 1 is wrong

Is This Answer Correct ?    39 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about the database management systems.

572


How you can make a parameterized view?

561


Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.

1610


How can I detect whether a given connection is blocked?

585


The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

580






What is normalization? Explain different levels of normalization?

59850


Explain about normal forms?

604


How to replace not in with not exist?

1470


What is an application role and explain a scenario when you would use one?

564


How to use timestamp datatypes

1583


Explain about xml databases?

626


Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

2014


Explain the rollup operator?

615


What are data modelling techniques?

530


Write short notes on manual refreshes.

2295