Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the select statement in sql?
- 0 Answers
- 1177 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What are tuples in sql?
What will you get by the cursor attribute sql%rowcount?
What is scalar and vector?
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 is the difference among union, minus and intersect?
How to run sql functions in pl/sql?
What are sql injection vulnerabilities?
How do you take the union of two tables in sql?
how to create object in plsql
what is the difference between undefined value and null value? : Sql dba
Explain the difference between rename and alias?
-
Oracle (3253) - 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)
