What is union and union all keyword in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is union?
State the advatage and disadvantage of Cursor's?
How do I upgrade sql?
What are the commands used in sql?
how to create a primary key with out creating an index?
Why do we use sql constraints?
How many postgresql users are there, worldwide?
What are types of exception?
What are different joins used in sql?
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
need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
what are the authentication modes in sql server? How can it be changed? : Sql dba