Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 inserted duplicate names with scores −mysql> insert into DemoTable1338 values('Chris', 8); Query OK, 1 row affected (0.80 sec) mysql> insert into DemoTable1338 values('Bob', 4); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable1338 values('Bob', 9); Query OK, 1 row affected (0.27 sec) mysql> insert into DemoTable1338 values('Chris', 6); ... Read More
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 values to a methodIt has one property −Item1 − Get the value of the current Tuple object's first component.ExampleLet us now see an example to implement the 1-tuple in C# −using System; public class Demo { public static void Main(string[] args) { Tuple tuple = new ... Read More
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 OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1337 values('Value345'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1337 values('Value567'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1337 values('Value489'); Query OK, 1 row affected (0.22 sec)Display all records from the table using select statement ... Read More
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; border: 2px blue dashed; } $(document).ready(function(){ $(":disabled").addClass("one"); }); ID: Rank: Fav. Subjects: Maths: English OutputThis will produce the following output −
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 | % | | Charlie | % | | Robert | % | | User2 | % | | mysql.infoschema | % ... Read More
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 us now see an example to implement Math.Truncate() method −using System; public class Demo { public static void Main(){ Decimal val1 = 25.46467m; Decimal val2 = 45.9989m; Decimal val3 = 678.325m; Console.WriteLine(Math.Truncate(val1)); Console.WriteLine(Math.Truncate(val2)); ... Read More
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 − .one { color: brown; background-color: orange; font-size: 16px; border: 2px blue dashed; } $(document).ready(function(){ $("p:contains(the)").addClass("one"); }); Examination Timings: 10AM - 1PM The examination hall details would be emailed to the students. OutputThis will produce the following output −
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 into DemoTable1336 values('John', NULL); Query OK, 1 row affected (0.21 sec) mysql> insert into DemoTable1336 values(NULL, 'Chris'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1336 values('David', 'Mike'); Query OK, 1 row affected (0.18 sec)Display all records from the table using select statement −mysql> select * from DemoTable1336;This ... Read More
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 = 30.0; double val2 = (60 * (Math.PI)) / 180; Console.WriteLine(Math.Tanh(val1)); Console.WriteLine(Math.Tanh(val2)); } }OutputThis will produce the following output −1 0.780714435359268ExampleLet us see another example to implement Math.Tanh() method −using System; public class Demo { public static void Main(){ ... Read More
The :checked selector in jQuery is used to look for all the checked radio button or checkboxes and selects them.SyntaxThe syntax is as follows −$(":checked")ExampleLet us now implement the :checked selector in jQuery − Favourite Subject Maths: English $( "input" ).on( "click", function() { $( "#content" ).html( $( "input:checked" ).val() + " is the favourite subject" ); }); OutputThis will produce the following output −Select “Maths” radio button above −Now, select “English” radio button −