Home » RDBMS Server » Server Administration » sql
sql [message #373748] Fri, 04 May 2001 02:17
yonca
Messages: 3
Registered: April 2001
Junior Member
i have got a table below,

field value
1 a
2 s
3 d
4 f
5 g
1 h
2 j
3 k
4 l
5 w
1 e
2 r
3 t
4 y
5 u

and i want to create a new view which seems like below,

1 2 3 4 5
a s d f g
h j k l w
e r t y u

how can i do that should you pls help me?

Report message to a moderator

Previous Topic: DBA Certification Test
Next Topic: SQL Query Problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:31:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.