What is clustered and nonclustered index in sql?
No Answer is Posted For this Question
Be the First to Post Answer
Which language is used in sql?
Write a sql select query that only returns each name only once from a table?
What are triggers and its uses?
what is the difference between myisam static and myisam dynamic? : Sql dba
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,
how to decrement dates by 1 in mysql? : Sql dba
What is a cursor for loop ?
which operator is used in query for pattern matching? : Sql dba
Is clustered index a primary key?
Is oracle and sql same?
How do you display "13th of November, 17 days left for month end" without hardcoding the date.
Is sql low level language?
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)