What is the significance of null value and why should we avoid permitting null values?
No Answer is Posted For this Question
Be the First to Post Answer
What is the cartesian product of table?
What is user-defined functions? What are the types of user-defined functions that can be created?
What is sql or structured query language?
How to test values returned by a subquery with the in operator?
Can Having clause be used without Group by clause?
6 Answers CarrizalSoft Technologies, CSC, CTS,
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
How to rebuild all indexes on a single table?
How to create a view with data from multiple tables?
What is the appropriate number of test cases that you can write on a database?
What is a trigger and types of a trigger?
What are the dmvs? : sql server database administration
Delete duplicate rows without using rowid.
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)