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) In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;
5 23642SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
TCS,
6 14392I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?
2 8017
Name at least six file extensions of Microsoft Access?
What is microsoft access made up of?
Explain the properties of the relational tables?
what does the automatic recovery do? : Sql server administration
What is the Structural difference between bitmap and b-tree index ?
How to add additional conditions in SQL?
Explain the the delete statements in sql?
How to move objects from DEV to QA and QA to PROD Environments?
How to defragment table indexes?
Hi Can any one tell me what are the API's used in requisition import.
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are information schema views?
What is query cost in sql server?
How to create a postgresql database?
What is a left join mysql?