adspace
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) Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz
3 5866Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
IBM,
1 4126in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out
4 6171Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
1 4755emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 3522I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
2 5628
What is acid mean in sql server?
Is inner join faster than left join?
what is the age limit for groups1 examination
How do I find the sql server version?
Is there some bulk load or other way to import a lot of data fast?
What is the difference between case version and decode version?
How to use values from other tables in update statements using oracle?
do you know how to configure db2 side of the application? : Sql server database administration
How efficient you are in oracle and SQL server?
What is temporary table in sql server? Why we use temp table?
what is the difference between openrowset and openquery?
What is a concurrency problem in dbms?
how to escape special characters in sql statements? : Sql dba
How to enter binary string literals in ms sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration