Ankith Reddy has Published 1070 Articles

How is it possible to filter out the duplications in the rows of result set return by MySQL?

Ankith Reddy

Ankith Reddy

Updated on 20-Jun-2020 06:30:30

72 Views

It can be possible by using the DISTINCT keyword in SELECT clause. The DISTINCT applies to the combination of all data fields specified in SELECT clause.ExampleWe have the table ‘Student’ on which we have applied DISTINCT keyword as follows −mysql> Select * from student; +------+---------+---------+-----------+ | Id   | ... Read More

How can we get sorted output based on multiple columns?

Ankith Reddy

Ankith Reddy

Updated on 20-Jun-2020 06:25:11

120 Views

We can specify multiple columns in ORDER BY clause to get the sorted output based on those multiple columns. Following as an example to make this concept clearer −mysql> Select * from Student ORDER BY Name, Address; +------+---------+---------+-----------+ | Id   | Name    | Address | Subject   ... Read More

CSS speech-rate property

Ankith Reddy

Ankith Reddy

Updated on 19-Jun-2020 16:38:17

108 Views

The speech-rate property specifies the speaking rate. Note that both absolute and relative keyword values are allowed.The possible values are -number − Specifies the speaking rate in words per minute.x-slow − Same as 80 words per minute.slow − Same as 120 words per minute.medium − Same as 180 - 200 words ... Read More

Java program to calculate mean of given numbers

Ankith Reddy

Ankith Reddy

Updated on 19-Jun-2020 14:54:39

5K+ Views

Mean is an average value of given set of numbers. It is calculated similarly to that of the average value. Adding all given number together and then dividing them by the total number of values produces mean.For Example Mean of 3, 5, 2, 7, 3 is (3 + 5 + 2 ... Read More

What is the use of DEFAULT constraint? How can it be applied to a column while creating a table?

Ankith Reddy

Ankith Reddy

Updated on 19-Jun-2020 13:38:37

72 Views

DEFAULT constraint is used set a default value for a column in MySQL table. If it is applied on a column then it will take the default value of not giving any value for that column. Its syntax would be as follows −SyntaxDEFAULT default_valueHere, default_value is the default value set ... Read More

Network Standardization

Ankith Reddy

Ankith Reddy

Updated on 18-Jun-2020 07:08:49

18K+ Views

Network StandardsNetworking standards define the rules for data communications that are needed for interoperability of networking technologies and processes. Standards help in creating and maintaining open markets and allow different vendors to compete on the basis of the quality of their products while being compatible with existing market products.During data ... Read More

Who’s Who in the International Standards World

Ankith Reddy

Ankith Reddy

Updated on 18-Jun-2020 07:05:52

236 Views

International Standards are needed so that products and systems developed in different parts of the world are interoperable and compatible with each other. The standards aim to ease out the technical differences and also to ensure product safety.The most prominent organization that lays down international standards is the ISO (International ... Read More

X.25 and Frame Relay

Ankith Reddy

Ankith Reddy

Updated on 17-Jun-2020 15:04:06

12K+ Views

X.25X.25 is a protocol suite defined by ITU-T for packet switched communications over WAN (Wide Area Network). It was originally designed for use in the 1970s and became very popular in 1980s. Presently, it is used for networks for ATMs and credit card verification. It allows multiple logical channels to ... Read More

Basic Ethernet

Ankith Reddy

Ankith Reddy

Updated on 17-Jun-2020 14:59:31

6K+ Views

Ethernet is a set of technologies and protocols that are used primarily in LANs. However, Ethernet can also be used in MANs and even WANs. It was first standardized in the 1980s as IEEE 802.3 standard. Since then, it has gone through four generations, as shown in the following chartStandard ... Read More

How to print Narcissistic(Armstrong) Numbers with Python?

Ankith Reddy

Ankith Reddy

Updated on 17-Jun-2020 14:54:08

284 Views

To print Narcissistic Numbers, let's first look at the definition of it. It is a number that is the sum of its own digits each raised to the power of the number of digits. For example, 1, 153, 370 are all Narcissistic numbers. You can print these numbers by running ... Read More

Advertisements