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
Database Articles
Page 366 of 547
Select count of values (Yes, No) with same ids but different corresponding records in MySQL?
For this, you can use SUM() along with CASE statement. Let us first create a −mysql> create table DemoTable1430 -> ( -> EmployeeId int, -> isMarried ENUM('YES', 'NO') -> ); Query OK, 0 rows affected (0.60 sec)Insert some records in the table using insert −mysql> insert into DemoTable1430 values(1001, 'Yes'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable1430 values(1001, 'No'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1430 values(1001, 'Yes'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable1430 values(1001, 'Yes'); Query OK, 1 row affected (0.16 sec)Display ...
Read MoreFetch date records comparing with the current date's day and month in MySQL
For this, use MONTH() and DAY(). Let us first create a −mysql> create table DemoTable1429 -> ( -> AnniversaryDate date -> );Insert some records in the table using insert −mysql> insert into DemoTable1429 values('2019-09-29'); Query OK, 1 row affected (0.09 sec) mysql> insert into DemoTable1429 values('2018-09-27'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1429 values('2016-09-28'); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1429 values('2015-09-29'); Query OK, 1 row affected (0.12 sec)Display all records from the table using select −mysql> select * from DemoTable1429;This will produce the following output −+-----------------+ | AnniversaryDate ...
Read MoreCount the number of comma's in every record from a comma-separated value column in MySQL
Let us first create a −mysql> create table DemoTable1510 -> ( -> Value varchar(50) -> ); Query OK, 0 rows affected (6.75 sec)Insert some records in the table using insert −mysql> insert into DemoTable1510 values('20, 35'); Query OK, 1 row affected (0.57 sec) mysql> insert into DemoTable1510 values('45, 67, 89'); Query OK, 1 row affected (0.99 sec) mysql> insert into DemoTable1510 values('90, 97, 101, 190'); Query OK, 1 row affected (1.15 sec)Display all records from the table using select −mysql> select * from DemoTable1510;This will produce the following output −+---------------+ | Value | ...
Read MoreFilter column value by the first character in MySQL
You can use LEFT() from MySQL. Let us first create a −mysql> create table DemoTable1428 -> ( -> EmployeeId int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> EmployeeName varchar(20) -> ); Query OK, 0 rows affected (1.05 sec)Insert some records in the table using insert −mysql> insert into DemoTable1428(EmployeeName) values('Chris Brown'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1428(EmployeeName) values('Bob Brown'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1428(EmployeeName) values('John Smith'); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable1428(EmployeeName) values('David Miller'); Query OK, 1 row affected (0.18 sec) ...
Read MoreExclude rows based on column value when another duplicate column value is found in MySQL?
For this, you can use subquery. Let us first create a −mysql> create table DemoTable1427 -> ( -> StudentId int, -> StudentMarks int -> ); Query OK, 0 rows affected (1.28 sec)Insert some records in the table using insert −mysql> insert into DemoTable1427 values(201, 89); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable1427 values(201, 99); Query OK, 1 row affected (0.18 sec) mysql> insert into DemoTable1427 values(210, 98); Query OK, 1 row affected (0.16 sec)Display all records from the table using select −mysql> select * from DemoTable1427 ;This will produce the following output ...
Read MoreHow to simulate the LIMIT MySQL clause with an Access database?
In Microsoft Access, you can use TOP instead of LIMIT. Let us first create a −Insert some records in the table using insert command −Following is the query to simulate the LIMIT MySQL clause with an Access database −After clicking Run, you will get the desired output −In MySQL, to get top 5 values, you need to use LIMIT 5 −
Read MoreMySQL query to order records but fix a specific name and display rest of the values (only some) random
For this, you can use ORDER BY RAND() with LIMIT. Let us first create a −mysql> create table DemoTable1426 -> ( -> FirstName varchar(20) -> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table using insert −mysql> insert into DemoTable1426 values('John'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable1426 values('Adam'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable1426 values('Robert'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1426 values('David'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1426 values('Sam'); Query OK, 1 row ...
Read MoreIs it possible to combine 'DISTINCT' and 'COUNT' queries, so that I can see how many times each distinct value appears in a MySQL table column?
Yes, you can use aggregate function COUNT(*) along with GROUP BY clause. Let us first create a −mysql> create table DemoTable1425 -> ( -> JoiningYear int -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using insert −mysql> insert into DemoTable1425 values(2000); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1425 values(2010); Query OK, 1 row affected (0.24 sec) mysql> insert into DemoTable1425 values(2015); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable1425 values(2000); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1425 values(2010); Query OK, ...
Read MoreMySQL query to replace part of string before dot
For this, use CONCAT() along with SUBSTRING_INDEX(). Let us first create a −mysql> create table DemoTable1424 -> ( -> Value varchar(60) -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert −mysql> insert into DemoTable1424 values('567.78483733'); Query OK, 1 row affected (0.78 sec) mysql> insert into DemoTable1424 values('1023.45252443'); Query OK, 1 row affected (0.15 sec) mysql> insert into DemoTable1424 values('7893322.5635543434'); Query OK, 1 row affected (0.35 sec) mysql> insert into DemoTable1424 values('90944.665665'); Query OK, 1 row affected (0.14 sec)Display all records from the table using select −mysql> select * from DemoTable1424;This ...
Read MoreReplace records based on conditions in MySQL?
To set conditions, use MySQL CASE statement. Let us first create a −mysql> create table DemoTable1481 -> ( -> PlayerScore int -> ); Query OK, 0 rows affected (0.42 sec)Insert some records in the table using insert −mysql> insert into DemoTable1481 values(454); Query OK, 1 row affected (0.41 sec) mysql> insert into DemoTable1481 values(765); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable1481 values(890); Query OK, 1 row affected (0.09 sec)Display all records from the table using select −mysql> select * from DemoTable1481;This will produce the following output −+-------------+ | PlayerScore | +-------------+ | ...
Read More