AmitDiwan has Published 10740 Articles

jQuery :empty Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:13:15

263 Views

The :empty selector in jQuery is used to select all elements which are empty.SyntaxThe syntax is as follows −$(":empty")ExampleLet us now see an example to implement the :empty() selector −    .demo {       color: brown;       background-color: orange;       font-size: ... Read More

Using MySQL where clause and ordering by avg() to find the average of duplicate individual elements

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:12:03

257 Views

For this, use having clause instead of where. Let us first create a table −mysql> create table DemoTable1338    -> (    -> Name varchar(10),    -> Score int    -> ); Query OK, 0 rows affected (1.54 sec)Insert some records in the table using insert command. Here, we have ... Read More

Tuple Class in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:11:46

141 Views

The Tuple class represents a 1-tuple, which is called singleton. A tuple is a data structure that has a sequence of elements.It is used in −Easier access to a data set.Easier manipulation of a data set.To represent a single set of data.To return multiple values from a methodTo pass multiple ... Read More

Fetch maximum value from a column with values as string numbers like Value440, Value345, etc. in SQL

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:08:47

118 Views

For this, you can use MAX() along with substring(). Let us first create a table −mysql> create table DemoTable1337    -> (    -> Value varchar(50)    -> ); Query OK, 0 rows affected (0.58 sec)Insert some records in the table using insert command −mysql> insert into DemoTable1337 values('Value400'); Query ... Read More

jQuery :disabled Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:07:30

325 Views

The :disabled() selector in jQuery is used to select all disabled input elements.SyntaxThe syntax is as follows −$(":disabled")ExampleLet us now see an example to implement the :disabled() selector −    .one {       color: brown;       background-color: orange;       font-size: 16px; ... Read More

Display all grants of a specific user in MySQL

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:05:58

188 Views

Let us first display all usernames along with host name −mysql> select user, host from MySQL.user;This will produce the following output −+------------------+-----------+ | user             | host      | +------------------+-----------+ | Bob              | %         ... Read More

Math.Truncate() Method in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:05:05

635 Views

The Math.Truncate() method in C# is used to compute an integral part of a number, which is Double or Decimal.Syntaxpublic static decimal Truncate(decimal val1) public static double Truncate(double val2)Above, there are two syntaxes. The value val1 is the decimal number to truncate, whereas val2 is the double number to truncate.ExampleLet ... Read More

jQuery :contains() Selector

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:03:51

534 Views

The :contain() selector in jQuery is used to select elements containing the specified text.SyntaxThe syntax is as follows −$(":contains(text)")Here, the parameter text is the text to find. The same elements are selected with the specified text.ExampleLet us now see an example to implement the :contains() selector − ... Read More

Select different fields in MySQL even if a field is set to null?

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:01:32

192 Views

For this, you can use COALESCE(). Let us first create a table −mysql> create table DemoTable1336    -> (    -> FirstName varchar(20)    -> ,    -> SecondName varchar(20)    -> ); Query OK, 0 rows affected (0.64 sec)Insert some records in the table using insert command −mysql> insert ... Read More

Math.Tanh() Method in C#

AmitDiwan

AmitDiwan

Updated on 05-Nov-2019 07:01:26

130 Views

The Math.Tanh() method in C# is used to return the hyperbolic tangent of the specified angle.Syntaxpublic static double Tanh (double val);Above, Val is the angle.ExampleLet us now see an example to implement Math.Tanh() method −using System; public class Demo {    public static void Main(){       double val1 ... Read More

Advertisements