what is the difference between count(*) and count(1) ?
No Answer is Posted For this Question
Be the First to Post Answer
What are partitioned views?
What is the purpose of indexing?
what is the sql equivaent of the dataset relation object ?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
How to provide default values to function parameters?
How dts is used to extract, transform and consolidate data?
how many layers of tcp/ip protocol combined of? : Sql server database administration
How to return the date part only from a sql server datetime datatype?
When do u use clustered index and non-clustered index?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
What is ms sql server index?
How to get the definition of a stored procedure back?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)