What are the standard SQL commands?

Asked by Melissajanuary, Last updated: Mar 27, 2024

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link

1 Answer

Answered Apr 25, 2019

COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any of the columns
COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column

Write Your Answer

More SQL Questions

What is the purpose of SQL AS clause?
What is the difference between Left Join and Left Outer Join?
What is the purpose of SQL?
What is the difference between UDF and stored procedure in SQL?
What is the difference between Python and SQL?
What is the difference between SQL and HQL?
What is the difference between SQL and T-SQL?
What is the difference between MS SQL Server and Oracle?
What can UPDATE SQL clause do?
What does the 'find' and the 'findNoCase' function return?

Ask Your Own Question

Can You Answer

What is the default value of %NOTFOUND in cusor attribute?
Can you use both HAVING and WHERE SQL clauses in one SQL statement?

Topics Related To SQL

Oracle

What are the standard SQL commands?

+ Answer Request 0Follow Share Answer AnonymouslyAnswer Later Copy Link

melissajanuary

More SQL Questions

Can You Answer

Topics Related To SQL

+ Answer

Request

0
Follow

Share

Answer Anonymously
Answer Later

Copy Link