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
- 1 Answers
- 3498 Views
- I also Faced
- E-Mail Answers
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 to define testing of network layers? : Sql server database administration
What is the difference function and stored procedure?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What is tempdb database? : SQL Server Architecture
What is PROJECTION Operation?
How to count duplicated values in a column in ms sql server?
Is it safe to delete log files?
What is difference between rownum and rowid?
What are the different types of sub-queries?
What does the on delete cascade option do?
How to use order by with union operators in ms sql server?
What is difference between equi join and inner join?
What are the operating modes in which database mirroring runs?
What is the dbcc command and why is it used?
What is the difference between web edition and business edition?
