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 have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
DELL,
13 19552i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
NIC,
1881how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
6 7428i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2
5 9919
What is max pool size?
What is sqlcommand?
Where is trigger in sql server?
Describe triggers features and limitations?
What is a table partition?
What is an Oracle Data Segment?
explain GROUPBY & HAVING clause with examples.
Name three of the features managed by the surface area configuration tool? : sql server security
What are the restrictions applicable while creating views? : SQL Server Architecture
List the types of locking?
What are the limitations of database?
What is an access?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
what is insert all statement in sql
What is the rdbms concept in sql?