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
- 3978 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 is user defined stored procedures?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
on line cluster can we make if yes tell me the procedure
What is default port number for sql server 2000?
What is difference between standardization and normalization?
Explain the first normal form(1nf)?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What’s the use of custom fields in report?
What is a filestream?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How do you delete duplicate rows in sql server?
Define right outer join?
What does the on delete cascade option do?
How to add the custom code in Report?
Do you know data definition language, data control language and data manipulation language?
