sql - How do I remove repeated column values from report -

-

from this: 

hotel                     type   room guest                                              ------------------------- ------ ---- ----------------------------------------- --------- ---------     university inn & suites   double 101  george brown                              11-sep-10 14-sep-10     university inn & suites   double 101  george brown                              11-oct-10 13-oct-10     university inn & suites   double 102     university inn & suites   double 103     university inn & suites   double 104     university inn & suites   double 105     university inn & suites   family 106  george brooks                             22-sep-10 27-sep-10     university inn & suites   family 107     university inn & suites   single 201  sandra williams                           15-sep-10 19-sep-10     university inn & suites   single 201  liz armstrong                             16-sep-10 18-sep-10     university inn & suites   single 201  craig harper                              19-sep-10 22-sep-10     university inn & suites   single 202  roger harris                              03-sep-10 10-sep-10     university inn & suites   single 202  tonya harris                              23-sep-10 27-sep-10     university inn & suites   single 203     university inn & suites   single 204     university inn & suites   single 205

to this

    hotel                     type   room guest                                              ------------------------- ------ ---- ----------------------------------------- --------- ---------     university inn & suites   double 101  george brown                              11-sep-10 14-sep-10                                           george brown                              11-oct-10 13-oct-10                                      102                                        103                                      104                                      105                               family 106  george brooks                             22-sep-10 27-sep-10                                      107                               single 201  sandra williams                           15-sep-10 19-sep-10                                      201  liz armstrong                             16-sep-10 18-sep-10                                           craig harper                              19-sep-10 22-sep-10                                      202  roger harris                              03-sep-10 10-sep-10                                           tonya harris                              23-sep-10 27-sep-10                                      203                                      204                                      205

is structure of table showing (or) result of report?

my guess is result of sqlplus report. if case, , want hotel name appear once (until changes), can specify 

break on hotel;  select hotel, type, room_guest   hotels   order hotel;

to achieve desired result.

if structure, cannot delete column values first row. (in fact, there nothing first row far database concerned). if trying eliminate duplicate data, normalizing table.

http://en.wikipedia.org/wiki/database_normalization\

please post table description , tool (if any) you'd appropriate answers case.


Comments

Post a Comment

Popular posts from this blog

android - Spacing between the stars of a rating bar? -

-
ho can set spacing beween stars? thats ratingbar: ratingbar = (ratingbar) inflater.inflate(r.layout.ratingbar, null); ratingbar.setlayoutparams(new layoutparams(layoutparams.wrap_content, layoutparams.wrap_content)); the layout: <?xml version="1.0" encoding="utf-8"?> <ratingbar xmlns:android="http://schemas.android.com/apk/res/android" style="@style/mystyle" android:layout_alignparentright="true" android:layout_height="19dp" android:layout_width="wrap_content" android:numstars="5"> </ratingbar> the style: <style name="mystyle" parent="@android:style/widget.ratingbar"> <item name="android:progressdrawable">@drawable/android_r2_ratingstar_yellow</item> <item name="android:indeterminatedrawable">@drawable/android_r2_ratingstar_grey</item> </style> thanks, cheers you have ...
Read more

html - Instapaper-like algorithm -

-
does of algorithm extracts contents webpage? instapaper ? there 2 steps instapaper does: find main content block on page (excluding headers, footers, menus etc) from content block extract , format text to find content block (typically html block element, div containing key page text content) instapaper uses algorithm 1 used readability . can @ source of readability.js see what's going on, @ core tries find area on page highest text/link ratio, although has other simple scoring metrics (e.g. off top of head, things ratio of text commas, para elements etc) go heuristics. once have identified root node element, relevant content, you'll need format it, if want can pull node element containing text out of source document , insert yours, in reality you'll want remove existing styles , apply own, standard , feel. if want output nice text-only can use jericho's renderer . update1 : should mention else instapaper - follow 'pagination' links (...
Read more

c# - How to execute a particular part of code asynchronously in a class -

-
i creating speech recognition engine that's going respond user commands.i have created button enable , disable speech recognition per user convenience.i have used dispose() of speech engine disable speech recoginition.here code private void button1_click(object sender, routedeventargs e) { engineon = !engineon; if (engineon) { speechengine = speech.createspeechengine(); //speech class creates , returns new speech engine. speechengine.audiolevelupdated += new eventhandler<audiolevelupdatedeventargs>(speechengine_audiolevelupdated); // use system's default microphone speechengine.setinputtodefaultaudiodevice(); speechengine.loadgrammar(new dictationgrammar()); // start listening speechengine.recognizeasync(recognizemode.multiple); } else { speechclass.myengine.dispose(); } } but disposal of speech obj...
Read more