How can get second highest salary in sql?
Answer / Dilshad Ali
To find the second highest salary, you can use a subquery. Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
| Is This Answer Correct ? | 0 Yes | 0 No |
Can you upgrade sql express to full sql?
How do you run a query?
i have table T!. A B C D NULL 1 2 3 4 NULL 5 6 7 8 NULL 9 10 11 12 NULL. I WANT COUNT OF NULL VALUES IN TABLE. WRITE A QUERY.
how can we repair a mysql table? : Sql dba
What is input buffer in sql*plus?
Is sql between inclusive?
i have some prob lem to tell me about my self in interview first round ...
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
explain commit and rollback in mysql : sql dba
What is cartesian join in sql?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What does the sign mean in sql?
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)