One table Test with single column. These are the values in
the table
a
b
c
d
e
f
g
h
I need a query (without using any variable) with output as -
a b c
d e f
g h
Answer Posted / gopi muluka
Check this
DECLARE @Character TABLE
(
Ch VARCHAR(50)
)
INSERT INTO @Character
SELECT 'a' UNION
SELECT 'b' UNION
SELECT 'c' UNION
SELECT 'd' UNION
SELECT 'e' UNION
SELECT 'f' UNION
SELECT 'g' UNION
SELECT 'h' UNION
SELECT 'i' UNION
SELECT 'j' UNION
SELECT 'k' UNION
SELECT NULL
SELECT A.Ch,B.Ch,MAX(C.Ch)
FROM @Character A
CROSS JOIN @Character B
CROSS JOIN @Character C
WHERE ASCII(A.Ch)+1=ASCII(B.Ch) AND ASCII(A.Ch)% 3=1
AND ASCII(B.Ch)+1=ISNULL(ASCII(C.Ch),ASCII(B.Ch)+1) AND
ASCII(B.Ch)% 3=2
GROUP BY A.Ch,B.Ch
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can I create a new template for import ? : sql server management studio
What are the requirements to use odbc connections in php scripts?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
How sql server enhances scalability of the database system?
According to you what goes into making the best database administrator? : sql server database administration
what is the main function of a query parameter?
Give me a SQL Query to find out the second largest company?
What is the latest version of microsoft sql server?
Does the order of columns in update statements matter?
Does sql server use java?
How to create a scrollable cursor with the scroll option?
Define tempdb database?
What are the properties and different types of sub-queries?
What is the user of Primary key?
What is openrowset sql server?