AmitDiwan has Published 10740 Articles

Get the count of unique phone numbers from a column with phone numbers declared as BIGINT type in MySQL

AmitDiwan

AmitDiwan

Updated on 03-Oct-2019 06:04:24

783 Views

For this, you can use COUNT() along with DISTINCT. The COUNT() method is to count the records. However, the DISTINCT returns distinct records, whereas COUNT() method counts those unique records. Let us first create a table −mysql> create table DemoTable (    PhoneNumber bigint ); Query OK, 0 rows affected ... Read More

Only display row with highest ID in MySQL

AmitDiwan

AmitDiwan

Updated on 03-Oct-2019 06:02:55

213 Views

To order, use the ORDER BY DESC clause. With that, since we want a single ID, which should be the highest, use LIMIT 1. This will fetch the row with highest ID. Let us first create a table −mysql> create table DemoTable (    Id int,    FirstName varchar(50) ); ... Read More

HTML5 Semantics

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:58:14

975 Views

The HTML5 Semantics refers to the semantic tags that provide meaning to an HTML page. In HTML5 the tags are divided into two categories - semantic and non-semantic. HTML5 brings several new semantic tags to the HTML.Some HTML5 Semantic tags are −TagsExplanationfigureIt specifies an image with different formats.articleIt specifies an ... Read More

HTML Form action Attribute

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:55:02

2K+ Views

The HTML form action attribute defines where to send the form data when a form is submitted in an HTML document.SyntaxFollowing is the syntax −Let us see an example of HTML Form action Attribute −Example Live Demo    body {       color: #000;       height: ... Read More

HTML Window sessionStorage Property

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:51:40

352 Views

The HTML Window sessionStorage property allow us to store key/value pairs data in a web browser only for one session that means the data is deleted when the browser tab is closed.SyntaxFollowing is the syntax −window.sessionStorageLet us see an example of HTML Window sessionStorage Property −Example Live Demo   ... Read More

HTML Window self Property

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:48:09

196 Views

The HTML Window self property returns the current window of the browser.SyntaxFollowing is the syntax −window.selfLet us see an example of HTML Window self Property −Example Live Demo    body {       color: #000;       height: 100vh;       background-color: #8BC6EC;       ... Read More

HTML Window top Property

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:45:43

388 Views

The HTML Window top property returns the topmost browser window of the current window.SyntaxFollowing is the syntax −window.topLet us see an example of HTML Window top Property −Example Live Demo    body {       color: #000;       height: 100vh;       background-color: #8BC6EC;   ... Read More

HTML Window resizeTo() Method

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:41:39

401 Views

The HTML Window resizeTo() method resize a window relative to its current size by the specified values.SyntaxFollowing is the syntax −window.resizeTo(w, h)Here w and h define the value of resizing the window width and height in pixels respectively.Let us see an example of HTML Window resizeTo() Method −Example Live Demo ... Read More

HTML Window resizeBy() Method

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:38:14

156 Views

The HTML Window resizeBy() method resize the window relative to its current size by the specified values.SyntaxFollowing is the syntax −window.resizeBy(w, h)Here, w and h define the value of resizing the window width and height in pixels respectively.Let us see an example of HTML Window resizeBy() Method −Example Live Demo ... Read More

HTML Window moveTo() Method

AmitDiwan

AmitDiwan

Updated on 01-Oct-2019 11:34:54

270 Views

The HTML Window moveTo() method moves a window’s left and top edges to the specified coordinates.SyntaxFollowing is the syntax −window.moveTo(x, y)Here, x and y define the value of moving the window horizontally and vertically in pixels respectively.Let us see an example of HTML Window moveTo() Method −Example Live Demo ... Read More

Advertisements