ASP DOT NET

Monday, April 4, 2022

How to display only Decimal number

Using Sql Server 

SELECT FORMAT(2.3332232,'N2')


Using MySql 

SELECT ROUND(325.3547, 2);


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to to select duplicate rows from sql server?

 SELECT * FROM Recruitment WHERE Email IN (SELECT Email FROM Recruitment GROUP BY Email HAVING COUNT(*) > 1); WITH CTE AS (     SELECT   ...