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) I need to write a simple query,which one is better select statement or stored procedure?and why?
2 7022how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d
5 13605if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?
1 3707if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
2 3796if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
5 8786please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
8497i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
3 6815If we have n no of columns in a table, can we add new column in that table with not null constraint?
2 5885
What is mysql database extension?
What is bson in mongodb?
how to implement data validations?
how would you get the current date in mysql? : Sql dba
how to return query output in html format? : Sql dba
What is the clause we need to add in function body to return variable?
How do you configure to cache size for mmapv1 in mongodb?
What is importing utility?
How to execute a sql statement using odbc_exec()?
What is the purpose of scan?
What is difference between clustered and non clustered index?
What is sql server used for?
how you can create/delete databases in Neo4j?
What is default value database?
What do you mean by Oracle MEDIA RECOVERY?