What is a self join? Explain it with an example?
Answer Posted / mona
A table join to itself is known as self join.
select emp.ename,mngr.ename from emp.empl,emp.mngr where
emp.mngrno=mngr.empno
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
Explain the role of indexing in databases?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
What are the types of database model?
Why does this query return 0?
What is the database development process?
How to use online Backups?
What are the three types of database design?
What are the key features of dbms?
Explain about the hierarchical model of the database?
Explain about network model?
Write short notes on manual refreshes.
What are the main phases of database development?
I have a few records all are same structures data, I want to store data in multiple targets how
How to read and create .LDC data files which are used by linguatic dictionary.
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?