Interested to Buy Any Domain ? << Click Here >> for more details...
what are string data types? : Sql dba
- 0 Answers
- 971 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is union and union all keyword in sql and what are their differences?
What is auto increment feature in sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
Are views faster than queries?
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 nvarchar in sql?
How many developers work on postgresql?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
what are the advantages and disadvantages of views in a database? : Sql dba
Explain some predefined exceptions.
What is a dynamic query?
Explain how can you save or place your msg in a table?
-
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)
