Interested to Buy Any Domain ? << Click Here >> for more details...
Does view store data in sql?
- 0 Answers
- 969 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is a transaction?
What are the advantages of sql? Explain
What are actual parameters and formal parameters?
How do sql databases work?
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 reports view in oracle sql developer?
What is the use of primary key?
What is the difference between UNIQUE KEY and UNIQUE INDEX?
What are Global Temporary tables
How do I view an execution plan in sql?
What are the types of variable use in pl sql?
How to return an array from java to pl/sql?
-
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)
