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
Articles by Arjun Thakur
Page 50 of 75
How to select the maximum value of a column in MySQL?
You can use ORDER BY clause or aggregate function MAX() to select the maximum value.Using ORDER BYFollowing is the syntax −select yourColumnName from yourTableName order by yourColumnName desc limit 0, 1;Let us first create a table −mysql> create table DemoTable ( Number int ); Query OK, 0 rows affected (0.52 sec)Insert records in the table using insert command −mysql> insert into DemoTable values(790); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable values(746); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable values(480); Query OK, 1 row affected (0.15 sec) mysql> insert into ...
Read More8086 program to sort an integer array in descending order
In this program we will see how to sort array elements in descending order.Problem StatementWrite 8086 Assembly language program to sort in descending order of the elements in a given array, which is starts from memory offset 501. The size of the series is stored at memory offset 500.DiscussionHere we are sorting the number in bubble sorting technique. In this sorting technique there will be n passes for n different numbers. In ith pass the ith smallest element will be placed at the end. This is comparison based sort. We taking two consecutive numbers, compare them, and then swap them ...
Read MoreHow to add some rows to a table through DefaultTableModel in Java
Let us first create a demo table −JTable table = new JTable(tableModel);Now, add a column to it −tableModel.addColumn("Languages");Add some rows to the table using insertRow() method −tableModel.insertRow(0, new Object[] { "CSS" }); tableModel.insertRow(0, new Object[] { "HTML5" }); tableModel.insertRow(0, new Object[] { "JavaScript" }); tableModel.insertRow(0, new Object[] { "jQuery" }); tableModel.insertRow(0, new Object[] { "AngularJS" });The following is an example to add a row to a table with DefaultTableModel −Examplepackage my; import javax.swing.JFrame; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.table.DefaultTableModel; public class SwingDemo { public static void main(String[] argv) throws Exception { DefaultTableModel tableModel = new DefaultTableModel(); ...
Read MoreMySQL query to count frequency of students with the same age?
You can use COUNT(*) along with GROUP BY for this. Let us first create a table −mysql> create table DemoTable ( StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY, StudentAge int ); Query OK, 0 rows affected (0.59 sec)Insert records in the table using insert command −mysql> insert into DemoTable(StudentAge) values(16); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable(StudentAge) values(17); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(StudentAge) values(18); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(StudentAge) values(17); Query OK, 1 row affected (0.13 sec) mysql> insert into ...
Read MoreHow to update all dates in a Table?
You can use UPDATE with DATE_ADD() to update all dates. Let us first create a table −mysql> create table DemoTable ( ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientProjectDueDate date ); Query OK, 0 rows affected (1.19 sec)Insert records in the table using insert command −mysql> insert into DemoTable(ClientProjectDueDate) values('2018-01-21'); Query OK, 1 row affected (0.20 sec) mysql> insert into DemoTable(ClientProjectDueDate) values('2019-03-25'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable(ClientProjectDueDate) values('2013-11-01'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable(ClientProjectDueDate) values('2015-06-14'); Query OK, 1 row affected (0.23 sec)Display all records from ...
Read More8085 program to change states LEDs according to input switches.
Here we will see how to change the state of LEDs with the input switches using 8085.Problem StatementAccording to the ON/OFF states of input switches connected at port A change the states of output LEDs to ON/OFF states connected to port B.DiscussionTo solve this problem, we have to use the IN and OUT instructions. The IN instruction is used to take the input from the input port to the accumulator, and OUT instruction is used to send output from Accumulator to the output port. Here 8255 chip is used. In the port A of this chip is connected to the ...
Read MoreHow to concatenate all columns in MySQL?
First, you need to know how many columns are present in a table. Following is the syntax to know the column names −show columns from yourTableName;Following is the syntax to concatenate all columns −select concat(yourColumnName1, yourColumnName2, yourColumnName3, ........N) from yourTableName;Let us first create a table −mysql> create table DemoTable ( CustomerId int, CustomerName varchar(20), CustomerAge int ); Query OK, 0 rows affected (0.66 sec)Following is the query to know the exact column −mysql> show columns from DemoTable;This will produce the following output −+--------------+-------------+------+-----+---------+-------+ | Field | Type | Null ...
Read More8085 program to take all data except 00H from an array
Here we will see we can take all numbers which are not 00H from an array using 8085.Problem StatementWrite 8085 program to take all numbers which are not 00H from array, and store them into different location. Numbers are stored at 8001 onwards, 8000 is holding the size of array, the results will be stored from 9000.DiscussionTo solve this problem, we are taking the number from memory, then perform OR operation on the number and 00H. If the zero flag is enabled, then we can understand that the number was 00, so we just ignore that. Otherwise we just store ...
Read MoreHow to insert a document with date in MongoDB?
To insert a document with date in MongoDB, use Date(). Following is the syntax“yourFieldName”:new Date(yourDateValue);Let us create a collection with documents. Following is the query>db.insertDocumentWithDateDemo.insertOne({"UserName":"Larry", "UserMessage":"Hi", "UserMessagePostDate":new Date("2012-09-24")}); { "acknowledged" : true, "insertedId" : ObjectId("5c9cca58a629b87623db1b16") } >db.insertDocumentWithDateDemo.insertOne({"UserName":"Chris", "UserMessage":"Hello", "UserMessagePostDate":new Date("2015-12-31")}); { "acknowledged" : true, "insertedId" : ObjectId("5c9cca71a629b87623db1b17") } >db.insertDocumentWithDateDemo.insertOne({"UserName":"Robert", "UserMessage":"Bye", "UserMessagePostDate":new Date("2019-01-01")}); { "acknowledged" : true, "insertedId" : ObjectId("5c9cca85a629b87623db1b18") }Following is the query to display all documents from a collection with the help of find() method> db.insertDocumentWithDateDemo.find().pretty();This will produce the following output{ "_id" : ObjectId("5c9cca58a629b87623db1b16"), "UserName" : "Larry", "UserMessage" : "Hi", ...
Read MoreDoes deleting row from view delete row from base table in MySQL?
Yes, deleting row from view delete row from base table. Let us understand this by creating a new table. The query to create a table is as followsmysql> create table deleteFromBaseTableDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Name varchar(20) -> ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command. The query is as follows −mysql> insert into deleteFromBaseTableDemo(Name) values('John'); Query OK, 1 row affected (0.18 sec) mysql> insert into deleteFromBaseTableDemo(Name) values('Carol'); Query OK, 1 row affected ...
Read More