복수칼럼값중에 Max칼럼값 찾기
CREATE TABLE YY_백승희_max(id number, a NUMBER, b NUMBER, c NUMBER, d NUMBER, e NUMBER, f NUMBER, g NUMBER, h NUMBER); INSERT INTO YY_백승희_max VALUES(2345, 2, 3, 5, 1, 9, 6, 4, 8); SELECT id, MAX(a) FROM ( SELECT id, a FROM ttmp_max UNION ALL SELECT id, b FROM ttmp_max UNION ALL SELECT id, c FROM ttmp_max UNION ALL SELECT id, d FROM ttmp_max UNION ALL SELECT id, e FROM ttmp_max UNION ALL SELECT id, ..
더보기
Tray Icon 처리
unit Unit1; interface uses Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls, Buttons, ShellAPI, Menus; type TForm1 = class(TForm) BitBtn1: TBitBtn; PopupMenu1: TPopupMenu; CLOSE1: TMenuItem; N1: TMenuItem; N2: TMenuItem; procedure BitBtn1Click(Sender: TObject); procedure FormClose(Sender: TObject; var Action: TCloseAction); procedure CLOSE1Click(Sender..
더보기