Count function [message #673953] |
Wed, 19 December 2018 08:46 |
|
ABG
Messages: 5 Registered: April 2018
|
Junior Member |
|
|
I know the count function gives count of anything , But recently I have seen it being in the select list like
What does it means? I have also seen it being used in the middle of the select list like select ename,empno,count(*),sum(salary)... Please explain.
|
|
|
|
|
Re: Count function [message #673963 is a reply to message #673956] |
Wed, 19 December 2018 20:49 |
|
ABG
Messages: 5 Registered: April 2018
|
Junior Member |
|
|
Thanks a lot, Yes that was incorrect, I was rather refering to the code I have seen in this forum:
select e.*,max(cc.CC_DATE ) max_cc_date
What does it means, is it all the rows, when we use this kind of notation,please clarify
[Updated on: Wed, 19 December 2018 20:51] Report message to a moderator
|
|
|
|
Re: Count function [message #673970 is a reply to message #673966] |
Thu, 20 December 2018 03:28 |
cookiemonster
Messages: 13943 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
'select *' means select all columns from the tables in the from clauses.
'select <alias/table name>.*' means select all columns from the specified table.
And if you don't know that you should do a basic SQL course or read a good book on basic SQL.
|
|
|
|