how to convert character strings to dates? : Sql dba
No Answer is Posted For this Question
Be the First to Post Answer
Can we insert data into materialized view?
What do we need to check in database testing?
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 are tables and fields in the database?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
what is inline view?
What is vector point function?
Why is a primary key important?
What is localdb mssqllocaldb?
Authentication mechanisms in Sql Server ?
what is transaction? : Sql dba
How many developers work on postgresql?