Newest 'SQL' development Blogs - mysql

mysql

Featured

Find out a particular column throughout the database in Postgresql

Previously got a situation where I needed to get t
by Nitika.Verma

Tags

SQL SQL Server mysql Oracle mysql database SQL In operator SQL Server 2008 SQL wildcards Blog query WHERE clause Stored Procedure- Working XML sql joins Stored Procedure with arguments How to pass arguments to stored procedure stored procedure using parameter SQL ORDERBY Data Definition language SQL Delete Statement SQL Insert statement SQL Between Operator SQL less than Operator Categories of SQL Statements SQL Left Join SQL Distinct/Unique Statement SQL Inner Join Truncate Table php SQL Select TOP SQL LIKE Operator SQL ALIASES normalization Pivot in sql Restore XML how to connect with sql server . postgres particular column Use of Transaction and Try Catch in Stored Procedure Sys Commands Nth highest salary table Insert Data From One Table to Another Table in SQL ldf mdf Backup MSSQL Java

MySql: Display last conversation between multiple users in Inbox

SQL
NerdDigest
over 8 years ago

Retrieve last message between multiple users and display it in inbox Hello friends today I am going to tell you how to display last conversation in Inbox. For example: In whatsapp chat list we can see the last conversation of each us...

0
0
0
0
0
0
2.04k

How to use SQL Min () Function ?

SQL
NerdDigest
over 8 years ago

Hi Reader's, Welcome to FindNerd, today we are going to discuss how to use SQL Min () Function in Sql. SQL Min () Function is used for getting the minimum value from the selected field. Syntax of SQL Min (): se...

MySQL CONCAT Functions

SQL
NerdDigest
over 8 years ago

CONCAT function is mysql plays a vital role. The CONCAT() function combine or concatenate the list of strings together . We have 2 types of concat function -> CONCAT() – This function will concate list of string together without...

Combining Results of two or more SELECT Statements

SQL
NerdDigest
almost 9 years ago

Combining Results of two or SELECT Statements using UNION OPERATOR: UNION Operator is used to combine the results of two or more SELECT statements. But UNION operator does not return duplicate rows so to return duplicate rows UNION ALL operato...

what is the use of FORMAT() function in SQL?

SQL
NerdDigest
almost 9 years ago

In SQL, FORMAT() function is used to format a column value means how a field will to be displayed. FORMAT() Syntax SELECT FORMAT(column_name,format) FROM table_name; In the above syntax parameters are as below: Parameter Descri...

what is the use of NOW() function in SQL?

SQL
NerdDigest
almost 9 years ago

In SQL, NOW() function is used to return the current system date and time. NOW() Syntax SELECT NOW() FROM table_name; We have a table "employee" as below: employee id first_name last_name salary ........

SQL Tutorial -> Sql Inner Join

SQL
NerdDigest
almost 9 years ago

<-- Chapter 25: SQL Join Chapter 26 SQL Inner Join SQL Inner Join clause is used to fetch all the rows from more than two tables in which there is a match between the columns. Inner Join is similar like Join clause. Lets see an ...

Function in SQL

SQL
NerdDigest
almost 9 years ago

Function in SQL There are two type of function in sql SQL aggregate function 1) AVG() - Returns the average value SELECT AVG(column_name) FROM table_name 2) COUNT() - Returns the number of rows SELECT COUNT(column_name...