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…

AND & OR Syntax for SELECT Query in Mysql

AND & OR Syntax in Select Query can be used to filter the data from table column with multiple choices.

AND Syntax will show results only when both conditions are true but
OR  Syntax will show results even when one condition is true.

Example Table : For your reference


table_name
Column_name1Column_name2Column_name3Column_name4
1MalearticlesSam
2FemaledatabaseSam
3MalecodingJam
4MalecodingKam
5FemalecodingJam

Table Name is : table_name

AND Syntax Example

Query : "SELECT * from table_name WHERE Column_name3='articles' AND Column_name4='Sam'"

If you execute the above query then the first record will appear 


table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam


OR Syntax Example

Query : "SELECT *  from table_name WHERE Column_name3='articles' OR Column_name3='coding'"

If you execute the above query then the records which contains coding and articles from column_name3 will be displayed



table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam
3 Male coding Jam
4 Male coding Kam
5 Female coding Jam


AND & OR Syntax Example


Query : "SELECT *  from table_name WHERE Column_name4='Sam' AND (Column_name3='articles' OR Column_name3='coding') "


If you execute the above query then its mandatory to have Column_name4 with Sam data but for Column_name3 can have articles or coding

table_name
Column_name1 Column_name2 Column_name3 Column_name4
1 Male articles Sam

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