Login
Register
All Activity
Questions
Unanswered
Tags
Users
Ask a Question
About Us
986
Questions
785
Answers
Interview Preparation mode
beta
Funny Facebook Status
Enter your email address
All categories
SQL Server Interview Questions and Answers
(197)
SSIS Interview Questions and Answers
(54)
SSRS Interview Questions and Answers
(9)
SSAS Interview Questions and Answers
(29)
.NET Interview Questions and Answers
(186)
Oracle Interview Questions and Answers
(122)
Java Interview Questions and Answers
(32)
UNIX Interview Questions and Answers
(47)
Networking Interview Questions and Answers
(17)
MySQL Interview Questions and Answers
(30)
HR Interview Questions and Answers
(237)
General Interview Questions and Answers
(9)
Other Interview Questions and Answers
(8)
Job Openings
(3)
Greenplum Database Interview Questions and Answers
(5)
What is a self-join, in MS SQL Server?
Nice?
Vote!
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
–
edited
1 year
ago
by
R
sql-server-interview-question
t-sql
joins
1 Answer
Nice?
Vote!
self join is join the table to itself.
ex: select col1,col2 from tbl a inner join tbl b on a.col1=b.col2
there is only one table called in the above query tbl
answered
3 months
ago
by
anonymous
Related questions
Nice?
Vote!
Add
Ans!
What is “CROSS JOIN”, in MS SQL Server?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
t-sql
table
joins
Nice?
Vote!
1
answer
What are different types of joins in SQL, in MS SQL Server?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
database
t-sql
joins
Nice?
Vote!
Add
Ans!
What is a “CASE” statement in SQL, in MS SQL Server?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
t-sql
Nice?
Vote!
1
answer
What is a Sub-Query, in MS SQL Server?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
t-sql
Nice?
Vote!
1
answer
What is the default “SORT” order for a SQL, in MS SQL Server?
asked
1 year
ago
in
SQL Server Interview Questions and Answers
by
R
(
19,530
points)
sql-server-interview-question
t-sql