Select

Question 1

List ways to get count or records in a table

Answer 1

SELECT * FROM table1

SELECT COUNT(*) FROM table1

SELECT rows FROM sysindexes WHERE id = OBJECT_ID(table1) AND indid < 2

Question 2

Write a query to find the names of employees that begin with ‘A’

Answer 2

SELECT * FROM Table_name WHERE EmpName like ‘A%’

Question 3

Write a query to get the third-highest salary of an employee from an employee table

Answer 3

SELECT TOP 1 salary
FROM(
SELECT TOP 3 salary
FROM employee_table
ORDER BY salary DESC) AS emp
ORDER BY salary ASC;