Redmi Note 5 Specification And Price

Image
See the Redmi Note 5 Specification And Price

Display


18:9 Full screen displayCustom display with rounded corners
Procesor & Memory

Octa-core processorSnapdragon 625 2.0GHz maxAdreno 506Dimensions
Height: 158.5mmWidth: 75.45mmThickness: 8.05mmWeight: 180g

Display
18:9 Full screen display15.2cm (5.99) (diagonally)18:9 screen aspect ratio2160 x 1080 FHD+ resolution, 403 PPI, 1000:1 contrast ratio450 nits brightness84% of NTSC color gamutSunlight displayNight displayReading modeColor temperature adjustmentStandard mode
Battery
4000mAh (typ) / 3900mAh (min)Non-removable5V/2A
Camera & Video
12MP rear camera12MP, 1.25μm large pixel5-element lens, ƒ/2.2 apertureDual LED flashPDAFLow light enhancementHDRPanoramaBurst modeFace recognition5MP front cameraBeautify 4.0Selfie-lightSelfie countdownFace recognition1080p/720p video, 30fps
Networks & Connectivity
Supports 802.11a/b/g/n protocolsSupports 2.4 / 5G WiFi / WIFI Direct / WiFi DisplayBluetooth 4.2, Bluetooth HID4G dual SIM:
3-choose-2 hybrid S…

Distinct Syntax for SELECT Query in Mysql

If you have same data on the database table and you want to avoid duplication in your query result then you can use distinct word in mysql query to avoid duplication.

Example Table : For your reference


table_name
Column_name1Column_name2Column_name3Column_name4
1TecharticlesSam
2MysqldatabaseSam
3JavacodingJam
4J2eecodingKam
5HibernatecodingJam

Table Name is : table_name


The table table_name contains four column data but the column_name4 has 2 sam and 2 Jam but i want  to avoid sam and Jam with single results.


Query : "SELECT  DISTINCT Column_name4 from table_name"


If you execute the above query then the duplicate data from Column_name4 will be filtered.

table_name
Column_name4
Sam
Jam
Kam

Comments

Popular posts from this blog

Gradle project sync failed. Basic functionality (e.g, editing, debugging) will not work properly.

How Automation Can Make You Better at Your Job

Best Expense Manager App For Your Android Phone