Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3862 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
what's the maximum size of a row? : Sql server database administration
What is row_number function?
Which rendering formats are affected by the pagesize properties?
What is create statement?
How can you hide the sql server instances?
Where is my database stored on the hard disk in ms sql server?
Explain the use of containers in ssis?
Why variables called the most powerful component of ssis?
Explain aggregate functions?
Comment,Datatypes are unlimited
How can we rewrite sub-queries into simple select statements or with joins?
What is data block and how to define data block size?
what are the different types of replication you can set up in sql server? : Sql server database administration
Can sql servers linked to other servers like oracle?
What do you mean by subquery?
