How many commands are in sql?
No Answer is Posted For this Question
Be the First to Post Answer
display records from 5 to 9 using rowid or rownum
What is database white box testing and black box testing?
In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
How to disable a trigger name update_salary?
Where is all the data on the internet stored?
What is posting?
describe mysql connection using mysql binary. : Sql dba
Can a composite key be null?
What is sap sql?
what is 'mysqlcheck'? : Sql dba
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)