What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
No Answer is Posted For this Question
Be the First to Post Answer
Explain what is public role in sql server?
What is the optimization being performed in oracle and SQL Server?
What is a group function explain with an example?
What are the advantages of partitioning?
What is dknf in normalization form?
table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output
What is a user-defined function in the sql server and what is its advantage?
What is a cube? : sql server analysis services, ssas
What is difference between order by and group by?
Where do we use trace frag?
Explain various data region available in ssrs with their use?
What is the recovery model?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)