i have a table like this
Eno ename
1 a
2 b
3 c
i want to display ename and bossname from table
hint boss is also an employee
- 3 Answers
- 5449 Views
- NIIT, I also Faced
- E-Mail Answers
Answer Posted / saket
self join
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is an execution plan? How would you view the execution plan?
Find nth lowest salary or get nth lowest salary?
Does transparent data encryption provide encryption when transmitting data across the network?
How to use column default values in insert statements in ms sql server?
How would we use distinct statement? What is its use?
What extended events?
what kind of lan types do you know? : Sql server database administration
What is field in algebra?
How can you list all the table constraints in a database?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
How to transfer data from a cursor to variables with a "fetch" statement?
Can the “if update (colname)” statement be used in a delete trigger?
What are the requirements to use odbc connections in php scripts?
how can you attach more than 20 ldf files in sql server
Does partitioning ssd reduce performance?
