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
- 4040 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 many no of arguments can be passed in procedures and functions
How to insert stored procedure result into temporary table?
Write a program to fetch first 10 records from a file?
What is 2nf normalization?
According to you what goes into making the best database administrator? : sql server database administration
What command would you use to add a column to a table in sql server?
Explain having clause and where clause?
Is sql server a database?
What is the full form of dql?
What command is used to rename the database?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
State the difference between union and union all?
Does table partitioning improve performance?
What is clustered index
What is the difference between a primary key and a unique key? Are they the same?
