SELECT `id`
FROM table
GROUP BY id
HAVING COUNT(*) = 1
id column1 column2
--------------------------
1 value1 value2
1 value1 value2
2 value1 value2
Executing the above query will get a result
id
---
2
while occurence of the id = 2 is only once
Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c To make the Web browser control editable you have to write the following code while initializing. InitializeComponent(); webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>"; toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color if (colorDialog1.ShowDialog() == DialogResult.OK) ...
Kommentare
Kommentar veröffentlichen