Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Count number of times value appears in particular column in MySQL?
You can use aggregate function count() with group by. The syntax is as follows.select yourColumnName, count(*) as anyVariableName from yourtableName group by yourColumnName;To understand the above syntax, let us create a table. The query to create a table is as follows.mysql> create table CountSameValue -> ( -> Id int, -> Name varchar(100), -> Marks int -> ); Query OK, 0 rows affected (0.70 sec)Insert records in the table using insert command. The query is as follows.mysql> insert into CountSameValue values(1, 'Sam', 67); Query OK, 1 row affected (0.17 sec) mysql> insert into CountSameValue values(2, 'Mike', 87); Query OK, 1 ...
Read More8085 Program to perform bubble sort in ascending order
In this program we will see how to sort a block of bytes in ascending order using bubble sorting technique.Problem StatementWrite8085 Assembly language program to sort numbers in ascending order where n number of numbers are stored in consecutive memory locations starting from 8041H and the value of n is available in memory location 8040H (Using BUBBLE sort).DiscussionIn this program we will arrange the numbers in bubble sorting technique. In this sorting technique, it will be executed in different pass. In each pass the largest number is stored at the end of the list. Here we are taking the numbers ...
Read MoreHow to insert new cell into UITableView using Swift?
To insert a new cell into UITableView we'll first have to create a table view cell and then add it to the table view using Cell for row at method of Table view.We can create a cell using Storyboard or by creating a nib of class UITableViewCell.In the View controller drag and drop a table view and connect it's outlet to the ViewController class.Let's create a cell in the table view we just created and create it's class, call it CustomCell, and assign the class to cell.Give it an identifier "CustomCell"Add a label in the cell and change it to ...
Read MoreWhat is the equivalent of Java long in the context of MySQL variables?
The equivalent of Java long in the context of MySQL variables is BigInt.In Java, the long datatype takes 8 bytes while BigInt also takes the same number of bytes.Demo of Java longHere is the demo of Java long −public class JavaLongDemo { public static void main(String[]args) { long kilometer = 9223372036854775807L; System.out.println("The largest positive value for long range:"+kilometer); } }The following is the output −Demo of BigIntLet us see an example of BigInt type in MySQL. The following is the query to ...
Read MoreCount how many rows have the same value in MySQL?
To count how many rows have the same value using the function COUNT(*) and GROUP BY. The syntax is as follows −SELECT yourColumName1, count(*) as anyVariableName from yourTableName GROUP BY yourColumName1;To understand the above syntax, let us first create a table. The query to create a table is as follows −mysql> create table RowWithSameValue −> ( −> StudentId int, −> StudentName varchar(100), −> StudentMarks int −> ); Query OK, 0 rows affected (0.55 sec)Insert some records with same value. Here, we have added same marks for more than one student for our example. The query ...
Read MoreHow to change position of Toast in Android?
Before getting into an example, we should know what is toast in android. Toast is subclass for java.lang.Object and used to show a short message for a short period of time after that is going to disappear.This example demonstrates how to change the position of Toast in Android.Step 1 - Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 - Add the following code to res/layout/activity_main.xml. In the above code, we have taken a text view. when the user clicks on text ...
Read MoreWhat is an adjective clause in English grammar?
An adjective clause is a clause which performs the function of an adjective in a sentence. The adjective is a word which modifies a noun or pronoun in a sentence. For example, a tall man, (where tall is an adjective) etc.The adjective clause may be introduced by a relative pronoun (whom, which, that, who etc) or relative adverb (where, when, after, before etc).Examples of the Adjective ClauseRam, who is the monitor of our class, is intelligent.She is the neighbor, whose dog is Ill-behaved.Give me a reason why should I believe you.Here, 'who is the monitor of the class' in the ...
Read Morewhat are the latest apple products?
Here are some of the latest Apple products unveiled at Worldwide Developers Conference (WWDC) in June 2017.iMac ProApple introduced a brand new model for existing iMac which is focused on offering strong performances.All new iMac pro comes out with a 27-inch screen with 5K display and space gray finish.Now, the iMac will feature Intel Xenon processors with 8, 10 and 18 core options. It also comes with 128GB memory and one TB of storage space. It has 3 USB-c ports and includes new Radeon Vega graphics. It will be priced around 5000USD.iMacApple also announces upgrades for existing iMac systems. All ...
Read MoreSearch for a string within text column in MySQL?
You can search for a string within text column in MySQL with the help of LIKE clause. The syntax is as follows −select *from yourTableName where yourColumnName like '%anyStringValue%';To use the above syntax, let us first create a table −mysql> create table SearchTextDemo −> ( −> BookName TEXT −> ); Query OK, 0 rows affected (0.55 sec)Insert some strings in the table. The query is as follows −mysql> insert into SearchTextDemo values('Let us C'); Query OK, 1 row affected (0.28 sec) mysql> insert into SearchTextDemo values('C in Depth'); Query OK, 1 row affected (0.14 sec) ...
Read MoreWhat is a Yagi-uda antenna? What are its design specifications?
Yagi-Uda antenna is the most commonly used type of antenna for TV reception over the last few decades. It is the most popular and easy-to-use type of antenna with better performance, which is famous for its high gain and directivity. The frequency range in which the Yagi-Uda antennas operate is around 30 MHz to 3 GHz which belong to the VHF and UHF bands.Construction of Yagi-Uda AntennaA Yagi-Uda antenna was seen on top of almost every house during the 90's when we had only Doordarshan Channels. The parasitic elements and the dipole together form this Yagi-Uda antenna. It is seen ...
Read More