Answer Posted / Kunal Kishor
In SQL, you can use INNER JOIN or the SQL keyword WHERE to fetch common records from two tables. The result set contains only those rows where there is a match in the specified join column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are aggregate and scalar functions? : Sql dba
Can we rollback truncate?
how many tables will create when we create table, what are they? : Sql dba
Do we need to rebuild index after truncate?
define sql insert statement ? : Sql dba
Is primary key clustered index?
What is the best sql course?
how to use regular expression in pattern match conditions? : Sql dba
Is primary key always clustered index?
Can delete statement be rollbacked?
how to start mysql server? : Sql dba
what are the advantages of sql ? : Sql dba
how to escape special characters in sql statements? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
what are all the common sql function? : Sql dba
