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) A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
TCS,
7 11603How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com
35 60282Define the terms primary key foreign key and also the difference between primary and the unique key
2 11212If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?
2 4549if we want to load data from a text file into a mysql table, but the columns in table are 1st: code(int) and 2nd: city(varchar), but in text file the format is 1st cityname and then code separeted by delimeters. how to load?
2 5081
How to create function without parameter in sql server?
What is pl/sql table? Why it is used?
Define data, entity, domain and referential integrity?
Which command is used for user defined error messages?
How to create a new table from existing table in postgresql?
How to pad with leading zeros an int or smallint in sybase?
explain what is mysql? : Sql dba
Explain a checkpoint?
what is the stuff function and how does it differ from the replace function? : Sql dba
Give the various rollback segment states.
What is the difference between sql and psql?
What does a dba stand for?
What is degree of Relationship type?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How many types of index are there?