Which is faster count (*) or count 1?
No Answer is Posted For this Question
Be the First to Post Answer
Query for second maximum salary in each in each department
15 Answers DST Global Solutions, TCS,
declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?
how will be date change into string
How do you assign Construct the where clause without concatenating Field,value pairs?
What can I use instead of union in sql?
What is count * in sql?
what is collation? : Sql dba
Why triggers are used?
What is pl sql block in dbms?
How to start oracle sql developer?
What is sqlerrd?
how to increment dates by 1 in mysql? : Sql dba
Oracle (3253)
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)