how many triggers are allowed in mysql table? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
How would you reference column values before and after you have inserted and deleted triggers?
What is aggregate function in sql?
function can return multiple value?how give give sample coding
2 Answers 3i Infotech, CTS, Excelity Global, UHG,
What is pls integer?
What are basic techniques of indexing?
What is a recursive join sql?
Explain some predefined exceptions.
Which are sql * plus commands?
what are %TYPE and %ROWTYPE? what is the difference?
7 Answers ICICI, Saama Tech, Sail,
What is the use of time stamp in select statement?
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,
What type of database is sql?