Home » SQL & PL/SQL » SQL & PL/SQL » Needs Help about Query
Needs Help about Query [message #287004] Mon, 10 December 2007 22:00 Go to next message
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
Member

Dear Friend

I have data Like
ID time
01 08:00

02 08:10

03 08:11

04 08:15

01 17:00

01 17:01

02 17:05

---------------------------------------------
I need like this
id time1 time2
01 08:00 17:00
17:01

02 08:10 17:05

03 08:15


How it possible please give me a solution...

[Updated on: Tue, 11 December 2007 01:30]

Report message to a moderator

Re: Needs Help about Query [message #287011 is a reply to message #287004] Mon, 10 December 2007 22:55 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Search on form for "pivot" word.
http://www.google.ae/search?hl=en&q=pivot+query+oracle&meta=

Re: Needs Help about Query [message #287065 is a reply to message #287004] Tue, 11 December 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format. Use the "Preview Message" button.
Always post your Oracle version (4 decimals).

Regards
Michel
Re: Needs Help about Query [message #287562 is a reply to message #287004] Wed, 12 December 2007 12:26 Go to previous message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
while you are at it, how about giving us a real description of what you are trying to do.

Everyone else seems to get it, so I guess I am just more dense than most, but I have no clue yet what you are really asking (too many unansered questions (makes my head hurt)).

So I would appreciate an actual explanation of the goal, not just some pieces of what look like might be dates that make no real sense.

Kevin
Previous Topic: Help creating tab delimited file from sql
Next Topic: Need to convert amount in numbers into words
Goto Forum:
  


Current Time: Thu Feb 06 19:11:04 CST 2025