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 5772Suppose 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 4064in 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 6046Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
4720emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 3462I 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 5567
what is package and it uses and how can u call a package
Explain about integration services of Microsoft SQL server?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are the varoius components of physical database structure of oracle database?
How does sql developer connect to oracle database?
How to view existing locks on the database?
Is mongodb a relational database? Explain
What is the best alternative to microsoft access?
How do I edit a trigger in sql developer?
What is a pl/sql block?
What are the elements of a database?
What is oracle sql called?
Do you know what are the steps to process a single select statement?
Does oracle partitioning improve performance?
Compare sql & pl/sql