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 23611SELECT * 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 14349I 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 8005
How to import sql file in postgresql pgadmin 4?
difference between anonymous blocks and sub-programs.
What are properties of the transaction?
Can we call procedure inside function in oracle?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What do you understand by correlated subqueries in dbms?
What is key attribute?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
How I can use srw.run_report in reports6i?
Explain the structure of adaptive server enterprise?
How to select an exiting database using mssql_select_db()?
What is the difference between dropping a database and taking a database offline?
What do I do if I forgot my mysql root password?
What are the various editions of sql server 2017 that are available in the market?
What is the difference between python and sql?