How do you get all records from 2 tables. Which join do you use?
Answer Posted / sri
UNION ALL
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which tcp/ip port does sql server run?
What is varchar data type in sql?
How do you delete data from a table?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what is dbms? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
how would concatenate strings in mysql? : Sql dba
How do you create a db file?
What are the types of join and explain each?
Why function is used in sql?
Do we need to rebuild index after truncate?
What are stored procedures in mysql?
what is a primary key? : Sql dba
What is the left table in sql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)