How many types of Outer Joins?What are they?
Answer / g.ramesh
We have 3 Types of Outer Joins.
1.Left Outer Join
2.Right Outer Join
3.Full Outer Join
| Is This Answer Correct ? | 12 Yes | 0 No |
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3
What are sql dirty pages?
write a query to remove duplicate records without using primary key column?
how to overcome kernel isssues
Explain trigger and its types?
Explain the truncate command?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Explain go command in sql server?
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
What is mapping schema?
Does an index slow down updates on indexed columns?
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person
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)